Microsoft Project Macro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top