Conflicting Versions of Excel

[Ben W]

Hi,

I have a spreadsheet that I started on my home PC which has the latest
version of excel on. I have since been building the rest of the VB on
my work PC which uses Excel 97.
I have a macro which is linked to a button. When the user presses the
button, the macro puts some numbers into a table then saves and closes
the workbook. The problem I have is that I want the macro to
automatically save and close down the workbook without any dialogue
boxes or prompts. I get a prompt which says that the workbook was
originally created in a more recent version of excel, and do I still
want to save in the current version. The answer is yes and I don't
want that prompt to appear!

Easy I hear you cry, just use: Application.DisplayAlerts = False

The problem is when I use this code it doesn't save anything, so I'm
assuming by not displaying the warning message it sees it safer to not
save the new data.

How can I avoid the prompt and still save the data???

Appreciate any help!!

Many thanks,

Ben

 

[David McRitchie]

Hi Ben,
If you want to save you have to issue your own save.
Turning off Display Alerts just means you won't be
informed. I'd rather be an informed user than a hostage.


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Ben W]

Thanks, but this doesn't tell me how to sort this problem. The issue
I have is that I don't want the message to pop up telling the user
that it was created in another version and asking them to confirm they
want to save it in this version. The user will be aware that the
system will save and close down on clicking the macro, so I simply
want it to save and close down without this warning?

Any thoughts????

Hi Ben,
If you want to save you have to issue your own save.
Turning off Display Alerts just means you won't be
informed. I'd rather be an informed user than a hostage.


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hi,

I have a spreadsheet that I started on my home PC which has the latest
version of excel on. I have since been building the rest of the VB on
my work PC which uses Excel 97.
I have a macro which is linked to a button. When the user presses the
button, the macro puts some numbers into a table then saves and closes
the workbook. The problem I have is that I want the macro to
automatically save and close down the workbook without any dialogue
boxes or prompts. I get a prompt which says that the workbook was
originally created in a more recent version of excel, and do I still
want to save in the current version. The answer is yes and I don't
want that prompt to appear!

Easy I hear you cry, just use: Application.DisplayAlerts = False

The problem is when I use this code it doesn't save anything, so I'm
assuming by not displaying the warning message it sees it safer to not
save the new data.

How can I avoid the prompt and still save the data???

Appreciate any help!!

Many thanks,

Ben