Saving workbooks

  • Thread starter Thread starter Dell
  • Start date Start date
D

Dell

Hi,

I'm writing a macro that opens an Excel version 3 file,
changes it and then saves it.

Normally when you change an older version Excel file, you
get a prompt asking you if you want to update the file to
the new excel (in my case Excel 97) or leave it in the
current format.

How do you control this from within VBA, so you can decide
when it should update the file and when not.

Help appreciated.

Dell
 
use the fileformat argument to the SaveAs method of the workbook object.
 
You must log in or register to reply here.

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

Lose macros before saving 4
Toggling save warning message on or off 9
How to Unlock Excel Workbook protected by MACRO Password 6
Open a word mail-merge document from Excel VBA 1
Message still appears with DisplayAlerts = False & SaveChanges:=Fa 1
VBA editor doesn't prompt to save changes, doesn't save 3
forcing specific sheet opening upon launch of .xlsx file 4
Open and save blank workbook with Command Prompt 0

Back
Top