View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dell[_2_] Dell[_2_] is offline
external usenet poster
 
Posts: 1
Default Saving workbooks

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