A
Angie
Hi
I am trying to run a macro in Microsoft Project then opens an excel
file and then saves then saves it as a csv file. I have declared XL.
as a excel object and therefore this begins every line. I have then
used the following command:
XL.ActiveWorkbook.SaveAs FileName = "C:\Documents and
Settings\Desktop\TestScript3.csv" & FileFormat = xlCSV
But instead of creating a file called TestScript3.csv it creates a file
in My Documents called TRUE.xls or FALSE.xls. Can anyone tell me why
this is?
Thanks
Angie
I am trying to run a macro in Microsoft Project then opens an excel
file and then saves then saves it as a csv file. I have declared XL.
as a excel object and therefore this begins every line. I have then
used the following command:
XL.ActiveWorkbook.SaveAs FileName = "C:\Documents and
Settings\Desktop\TestScript3.csv" & FileFormat = xlCSV
But instead of creating a file called TestScript3.csv it creates a file
in My Documents called TRUE.xls or FALSE.xls. Can anyone tell me why
this is?
Thanks
Angie