HI

I'm using Excel 2003 and need to save a file as .xlsx so it can be read
in Excel 2007.

I'd like to add some VBA at the end of my macro to save the workbook in
this format. (myfile.xlsx)

Can someone advise if this is possible please?

Grateful for any advice.



Best Wishes

On Mon, 1 Jul 2013 23:44:15 +0100, Colin Hayes wrote:


HI

I'm using Excel 2003 and need to save a file as .xlsx so it can be read
in Excel 2007.

I'd like to add some VBA at the end of my macro to save the workbook in
this format. (myfile.xlsx)

Can someone advise if this is possible please?

Grateful for any advice.



Best Wishes

Excel 2007 can read .xls files - no need to save them as .xlsx which, so far as I know, is not possible using Excel 2003

Excel 2007 can read .xls files - no need to save them as .xlsx which, so far as I
know, is not possible using Excel 2003



Thanks for getting back.

The issue is that I'm being asked to upload a file to a parser in xlsx
format. It's an automated upload system.

I'm wondering if it will accept my xls file with no issues?

"Colin Hayes" wrote previously:
I'm using Excel 2003 and need to save a file as .xlsx so it
can be read in Excel 2007.
I'd like to add some VBA at the end of my macro to save the
workbook in this format. (myfile.xlsx)
Can someone advise if this is possible please?

"Colin Hayes" wrote later:
["Ron Rosenfeld" wrote:]
Excel 2007 can read .xls files - no need to save them as
.xlsx which, so far as I know, is not possible using Excel 2003
[....]
The issue is that I'm being asked to upload a file to a parser
in xlsx format. It's an automated upload system.
I'm wondering if it will accept my xls file with no issues?

There is no way for anyone to say for sure since you do not tell us the name
of the "parser" product, and even if you did, we probably do not know how
the "parser" works anyway.

There are other good reasons for saving an Excel 2003 file as .xlsx (or
..xlsm). Some of there a

1. So that the file is not limited to 256 columns and 65536 rows when opened
in Excel 2007 or later.

2. So that formulas are not recalculated when the file is opened in Excel
2007 or later.

3. So that the user of Excel 2007 or later does not get needless warnings
when saving the modified file.

In order to save as .xlsx or .xlsm using Excel 2003, download the Office
Compatibility Pack. See http://support.microsoft.com/kb/2526297.

Then you can use the following VBA code to save as .xlsx and optionally
close the file.

ActiveWorkbook.SaveAs Filename:= _
"driveName:\fullPath\myfile.xlsx", FileFormat:=51
ActiveWindow.Close

(Of course, replace "driveName" and "fullPath" with appropriate names.)

That will automatically invoke the file converter in the Compatibility Pack.

However, that presumes that the macro is not part of the saved file (i.e. it
is in another workbook), or that you do not intend for the macro to be saved
with the file.

If, instead, you want to save the macro with the XL2007-compatible file, you
need to save with the extension .xlsm. Also, change the FileFormat to 52
instead of 51.

On Mon, 1 Jul 2013 23:56:33 -0700, "joeu2004" wrote:

In order to save as .xlsx or .xlsm using Excel 2003, download the Office
Compatibility Pack. See http://support.microsoft.com/kb/2526297.

Didn't know that. Thanks for pointing that out. I've never used the Office Compatibility Pack and didn't realize it went "both ways".

In article , joeu2004
writes
In order to save as .xlsx or .xlsm using Excel 2003, download the Office
Compatibility Pack. See
http://support.microsoft.com/kb/2526297.

Then you can use the following VBA code to save as .xlsx and optionally close the
file.

ActiveWorkbook.SaveAs Filename:= _
"driveName:\fullPath\myfile.xlsx", FileFormat:=51
ActiveWindow.Close

(Of course, replace "driveName" and "fullPath" with appropriate names.)

That will automatically invoke the file converter in the Compatibility Pack.


Hi

OK Thanks for getting back. I tried this but without success ,
unfortunately.

I downloaded and installed

Microsoft Office Compatibility Pack Service Pack 3 (SP3).

I changed my current VBA from

ActiveWorkbook.SaveAs FileName:= _
"C:\My Documents\Spare\Zips\Upload
Files\Product_Upload_Ready.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False


To


ActiveWorkbook.SaveAs FileName:= _
"C:\My Documents\Spare\Zips\Upload
Files\Product_Upload_Ready.xlsx", _
FileFormat:=51, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False


and had no joy on running it. It gave errors I'm afraid. Any ideas how
to get this working?

Thanks.

"Colin Hayes" wrote:
joeu2004 writes:
In order to save as .xlsx or .xlsm using Excel 2003, download the Office
Compatibility Pack. See http://support.microsoft.com/kb/2526297.
[....]
I tried this but without success, unfortunately.

I'm sorry: apparently that is __just__ SP3. It might presume you already
have the base Office Compatibility Pack. See
http://www.microsoft.com/en-us/downl...ails.aspx?id=3.

Similarly, if and when you get around to installing SP3, see
http://www.microsoft.com/en-us/downl....aspx?id=27836 instead of the
KB that I pointed you to.

On Tue, 2 Jul 2013 01:28:49 +0100, Colin Hayes wrote:
The issue is that I'm being asked to upload a file to a parser in xlsx
format.


In that case, it was poor strategy to tell us you wanted to open the
files in Excel 2007.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

On Mon, 1 Jul 2013 23:44:15 +0100, Colin Hayes wrote:
I'm using Excel 2003 and need to save a file as .xlsx so it can be read
in Excel 2007.

No, you don't. Excel 2007 and 2010 can read .xls files just fine.
And I'll bet 2013 can too, though I haven't tried it.



--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...