Help with Access VBA Saving to Excel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top