FileFormatNum question?

Question

I'm a VBS novice...

I am have a script that opens a CSV file in Excel. The next step is to save the file as a Xlsm.

Here is my code but the file format number field shows in Red indicating something is wrong. I have tried FileFormatNum and with out the Num.

This is Excel 2013

Set objExcel = CreateObject("Excel.Application")

Set objWorkbook = objExcel.Workbooks.Open("C:\1datadump\datadump.csv")

objExcel.Application.Visible = True

objExcel.ActiveWorkbook.Save "C:\1datadump\datadump.xls", FileFormatNum:= 51

objExcel.ActiveWorkbook.Close

The VBS syntax is killing me. Every page I read is slightly different.

Answer 1

Thank you for your help Rick.

I changed to :

objExcel.ActiveWorkbook.SaveAs "C:\1datadump\datadump.xlsm", FileFormat:= 51

and I get:

Answer 2

The Save method does not provide for a FileFormatNum argument... it is the SaveAs method that does that although the argument name is FileFormat (no Num at the end of it).