Excel SaveAs method - requires file format??? 1

[sodakotahusker]

Where do I find the list of potential formats for the SaveAs command? I found xlCSV on a sample somewhere. I just want to save in Excel format. I don't get any intellisense help that guides me to this answer. How do I save as Excel??

 

[chrissie1]

try the vba forums they know a lot more about excell VBA.

Christiaan Baes
Belgium

"My new site" - Me

 

[SHelton]

If you use Type.Missing as the file format argument of SaveAs you will get the Excel format by default.

If you want to see a list of the available formats, open Object Browser and look in the interop.excel assembly. There is an enum called xlFileFormat which contains all the possible formats.

 

[sodakotahusker]

Thank you very much SHelton! Just what the doctor ordered!

 

[chrissie1]

Does it hurt to click this

Thank SHelton
for this valuable post!

Christiaan Baes
Belgium

"My new site" - Me

 

[Ruffnekk]

xlDoc.SaveAs("c:\temp.csv", FileFormat:=Excel.XlFileFormat.xlCSVWindows, AddToMru:=False, TextVisualLayout:=Excel.XlTextVisualLayoutType.xlTextVisualLTR, CreateBackup:=True)

xlDoc is an object of type Excel.Worksheet

Intellisense *will* show you the enumeration possibilities. Just try it by typing something similar in VB.

After typing "FileFormat:=Excel.XlFileFormat." intellisense will popup the possibilities for the XlFileFormat enumeration.

Regards, Ruffnekk
---
Is it true that cannibals don't eat clowns because they taste funny?