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.

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...

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...

"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.

In article , joeu2004
writes
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/download/details.aspx?id
=3.

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


Thank you for your kind help.

I did download and install these :

Microsoft Office Compatibility Pack (FileFormatConverters.exe)

Microsoft Office Compatibility Pack Service Pack 3 (SP3)

and also

Excelviewer.exe

It's just that I don't see anywhere within excel 2003 to save as xlsx if
I open a workbook and try to save in this format.

I tried also via VBA , and this too gives errors at the use of .xlsx as
a file type.

Having installed these compatibility programs , how to do I save in this
format form with excel 2003? I can't see any way at the moment. It's not
in the Save As dialog.

"Colin Hayes" wrote:
I did download and install these :
Microsoft Office Compatibility Pack (FileFormatConverters.exe)
Microsoft Office Compatibility Pack Service Pack 3 (SP3)
and also Excelviewer.exe
It's just that I don't see anywhere within excel 2003 to save
as xlsx if I open a workbook and try to save in this format.

Hmm, something is wrong. I don't know what it could be.

After I installed the Office Compatility Pack, .xlsx and .xlsm (et al) did
indeed appear in the choices in the Save As dialog box. I think this was
all automagic. I don't recall doing anything special. But it was a long
time ago.

The only thing I can imagine: do you have the Excel (or Office?) 2003 SP3
service pack?

If not, I would uninstall the Office Compatiblity downloads, update to Excel
(or Office) SP3, then re-download and install the Office Compatilibity
Packs.

If that does not work for you, you might SOL. At least, I am out of ideas.

PS: I would uninstall the Excelviewer. If you have Excel 2003, I cannot
imagine why you would need the viewer. I wonder if installing the viewer
after Excel 2003 is causing some confusion in what to load when you click on
an Excel file or otherwise start Excel. I don't know; I have no knowledge
of or experience with the viewer.

<FWIW
I installed the Compatibility Pack back when it was first available.
The Save/SaveAs options for v12 filetypes are added to the bottom of
the dropdown in v9/10/11 dialogs! (all have their respective latest
SPs)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

In article , joeu2004
writes
Hmm, something is wrong. I don't know what it could be.

After I installed the Office Compatility Pack, .xlsx and .xlsm (et al) did indeed
appear in the choices
in the Save As dialog box. I think this was all automagic. I don't recall doing
anything special. But
it was a long time ago.

The only thing I can imagine: do you have the Excel (or Office?) 2003 SP3 service
pack?

If not, I would uninstall the Office Compatiblity downloads, update to Excel (or
Office) SP3, then re-
download and install the Office Compatilibity Packs.

If that does not work for you, you might SOL. At least, I am out of ideas.

Hi

OK I got it working. Phew.

I uninstalled these :

Microsoft Office Compatibility Pack - FileFormatConverters

and

Microsoft Office Compatibility - ExcelViewer

and re-installed

Microsoft Office 2003 SP3

and

Microsoft Office Compatibility Pack - FileFormatConverters

and

Microsoft Office Compatibility Pack Service Pack 3 (SP3).

Now when I open the Save As dialog there are several new options
including xlsx xlsm and so on. Tried them and they all work fine.
Hooray!.

Not quite sure what the issue was before , but uninstall / reinstall
seems to have done the trick.

Thanks again for your help.