help!!!! change excel save format in vb6???

[werd]

i need to save a file as a "Microsoft Excel Workbook" which has been opened as a .txt file. At present all i can get is "Text (Tab-delimited)" irrespective of the filename

i'm using the following code in my application...
ExcelApp.ActiveWorkbook.SaveAs FileName:=FileName1

i know that using VBA it should look like this...
ActiveWorkbook.Saveas Filename:=FileName1, FileFormat:=xlNormal

can anyone tell me what the "FileFormat:=xlNormal" should be in VB6

Thanks.

 

[Bib]

vbnormal is only a file attribute (like not archive, or readonly...) why don't yu use directly
ActiveWorkbook.Saveas Filename:=FileName1, FileFormat:=xlExcel9795
let me know

 

[JohnYingling]

Get into Excel.
Start recording a Macro.
Do whatever it takes to get the file into an excel table.
Save it as Excel.
Stop recording.
Look at your macro to see the generated code.
Try this link for more tips.

http://msdn.microsoft.com/library/default.asp?URL=/library/techart/VSOfficeDev.htm

http://WWW.VBCompare.Com