hi all
i opened a csv file and copy the contents. i activated an excel file and have the copied contents from csv file pasted into excel file. now,how do i close the csv file programmatically?
A:
Some more information would be useful. How did you open the CSV file and copy it's contents to Excel? Did you do it with a programme that read the CSV file and inserted into Excel? Did you use the Windows clipboard somehow?
biozinc
2008-10-23 09:30:17
+1
A:
This should do it ..
Workbooks("MYCSV_File.CSV").Close SaveChanges:=False
dbb
2008-10-23 11:48:30