J
Jini
I have a module which creates a report with several
spreadsheets. After the report runs, if I try to save the
excel spreadsheet, I get the wrong file type. I looked at
the module and found the following line:
FileFormat:=xlExcel5, Password:="", WriteResPassword:="",
Does anyoneone know what I would put to replace the
xlExcel5 to save this file as a Microsoft Excel Workbook
instead.
I know this is a little thing, but it would save me time
each week.
Thanks in advance.
spreadsheets. After the report runs, if I try to save the
excel spreadsheet, I get the wrong file type. I looked at
the module and found the following line:
FileFormat:=xlExcel5, Password:="", WriteResPassword:="",
Does anyoneone know what I would put to replace the
xlExcel5 to save this file as a Microsoft Excel Workbook
instead.
I know this is a little thing, but it would save me time
each week.
Thanks in advance.