Using Save As

[DALIEN51]

I need a simple line of VBA code for Access 2000. I am using Access to open a XML file via Excel 2000 spreadsheet. After opening I want to use SAVEAS to save the file to a different location. In addition I want to specify the file format as Excel. What is the code to specify the file type as Excel?

My current code is :

myWorkBook.SaveAs (myPaths![Path])

So what do I need to add to this line to specify the file type?

Any help appreciated!

Dalien51

 

[namliam]

I would suggest you record your actions using the excel recording feature. And read there what it is.

(Yeah I dont know either )