gersemale
08-16-2005, 02:43 AM
Hi folks,
I have a strange problem here which I am unable to reproduce consistently.
Part of a macro I have written is that the user is prompted to highlight and copy results from a CSV file. The VBA then pastes this data to a worksheet
Worksheets("Paste Sheet").Cells(2, 91).PasteSpecial (xlAll)
However when I tested this on another users machine, the macro pasted a picture of the data, not a the actual data.
I cannot reproduce this on my own computer.
Could this be as a result of using different Clipboard copy methods? (CTRL C, CTRL INSERT, right click copy)?
Any help much appreciated!
Thanks,
Ger
I have a strange problem here which I am unable to reproduce consistently.
Part of a macro I have written is that the user is prompted to highlight and copy results from a CSV file. The VBA then pastes this data to a worksheet
Worksheets("Paste Sheet").Cells(2, 91).PasteSpecial (xlAll)
However when I tested this on another users machine, the macro pasted a picture of the data, not a the actual data.
I cannot reproduce this on my own computer.
Could this be as a result of using different Clipboard copy methods? (CTRL C, CTRL INSERT, right click copy)?
Any help much appreciated!
Thanks,
Ger