Import data to workbook - Paste values

Tip: Turn on the macro recorder and then do a paste special with the values only box ticked. Then look at the code that's been recorded and you'll have the correct format.

Thanks for the tip but this was not created using the macro recorder. It pulls data from a closed workbook at a specified location & AFAIK this action cannot be recorded.

Try:

Please Login or Register  to view this content.

Originally Posted by BPSJACK

Thanks for the tip but this was not created using the macro recorder. It pulls data from a closed workbook at a specified location & AFAIK this action cannot be recorded.

It really can. You'd be surprised. At the very least, an ordinary paste special with the values only box ticked recorded will give you the correct format of the command so you can edit your code. You're right in saying the entire procedure can't be recorded in this way (well, sort of, a bit, well ok it can but anyway), but it's perfect to get the correct format of a command without having to waste time Googling or waiting for a reply in here.