Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As 2003 in VBA not working
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suddenly Save and Save as greyed out in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 SP2 / SP3 Save / Save As over a WAN | Excel Discussion (Misc queries) | |||
Disable Save/Save As - not working? | Excel Discussion (Misc queries) | |||
Save as isn't working | Excel Discussion (Misc queries) | |||
Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working | Excel Worksheet Functions |