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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JNW - 29 Feb 2008 22:16 GMT

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,

Signature

JNW

Reply to this Message

JLGWhiz - 01 Mar 2008 01:22 GMT

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.

> I've got some code that closes a code generated workbook and saves during the
> close.
[quoted text clipped - 14 lines]
>
> Thanks,

Reply to this Message

Ron de Bruin - 01 Mar 2008 10:08 GMT

See
http://www.rondebruin.nl/saveas.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> I've got some code that closes a code generated workbook and saves during the
> close.
[quoted text clipped - 14 lines]
>
> Thanks,

Reply to this Message