PDA

View Full Version : Sleeper: VBA PasteSpecial (xlAll) pastes picture not data



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