save as .xls (97-03 format) with code

J

JNW

I've got some code that closes a code generated workbook and saves during the
close.

Workbooks(Workbooks.Count).Close _
savechanges:=True, _
Filename:=FName & "Myfile.xls"

FName is the folder location.

When running the code in xl2007 the code generated/closed/saved files can
only be opened in xl2007.

When running the code in xl2003 the files can be opened in both 07 and 03,
but when opening in 2007 there is a warning message first.

Has anyone seen this? and more importantly, does anyone know how to remedy it?

Thanks,
 
J

JLGWhiz

remember that xl07 has the 4 digit file extension and xl03 has only 3 digits.
I believe what you are seeing is the built in warning system to let you know
that you might be doing something you don't want to do.
 

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

Similar Threads

All Workbook Saved except This Workbook - Part2 3
Word 2003 won't exit 8
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
closing another file by code causes failure to run workbook activate event 2
How to create a bug report? 6
Auto save question 2
All Workbook Saved except This Workbook 3
Loop through workbooks 2

Top