View Full Version : Copy over a csv file contents, to a new sheet in a excel file not opening csv file?


j.smith1981
08-13-2010, 03:39 AM
Hi there.


I was wondering if there's anyway of allowing a macro to copy over data contents for a csv file (the whole file contents, which accumulates to about 7,000 rows), without copying and pasting, also if its possible is there anyway of making it do this without even opening the csv file?

The csv file is named pricelist.csv and is downloaded from an external FTP address.


Thanks in advance,
Jeremy.