Save As 2003 in VBA not working

R

RichieHop

Hi,

I've written some VBA code to save a series of workbooks in 2003 format from
an XLSM workbook. I've set "Application.DisplayAlerts = False" before the
code to save the book, but I still get the compatibility checker coming up
with "Minor Loss Of Fidelity".

I'm not bothered about this (it's only some colour changes), but it's a pain
to sit and answer OK for about 60 workbooks.

The full code is:

Application.DisplayAlerts = False
NewBook.SaveAs Filename:=strFileNameToSave,
FileFormat:=xlExcel8
Application.DisplayAlerts = True

Hope someone can help.

Cheers,

Richie
 

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

Save as Read only 2
Macro to save 2007 file in 97-2003 format 2
CSV code works on some, but not all machines 3
Compare two different workbook sheet to show the difference in text 0
Message still appears with DisplayAlerts = False & SaveChanges:=Fa 3
VBA code working in excel2003 but not in excel2007 2
vba code does not run 3
Save as, not overwrite 1

Top