Save file in XL97 and 2003
 

Hiya people!,

I wrote a little Macro that simply saves the workbook when a user clicks
a button Using ActiveWorkbook.Save

This was done in XL2003. I emailed into work for my work mate to start
using. Now when they use the save function instead of just saving it
pops up a message saing that it was written in a different version and
may not save correctly etc dialog box. hmmm ... not to much of a problem
as even if they continued it saved the data anyway, just the box is
anoying. So I added application.displayalerts = false ... the box does
not come up but the data is not saved??? Now I know i can simply get to
work a write the code again and wont get that message, but, as i am
working on more projects at home for work I do need to get this sorted.

So, why does this happen?

and

How do I stop it?

Save file in XL97 and 2003
 

Have a look at this site
http://www.rondebruin.nl/saveas.htm
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Steve J" wrote in message
6.253...
Hiya people!,

I wrote a little Macro that simply saves the workbook when a user clicks
a button Using ActiveWorkbook.Save

This was done in XL2003. I emailed into work for my work mate to start
using. Now when they use the save function instead of just saving it
pops up a message saing that it was written in a different version and
may not save correctly etc dialog box. hmmm ... not to much of a problem
as even if they continued it saved the data anyway, just the box is
anoying. So I added application.displayalerts = false ... the box does
not come up but the data is not saved??? Now I know i can simply get to
work a write the code again and wont get that message, but, as i am
working on more projects at home for work I do need to get this sorted.

So, why does this happen?

and

How do I stop it?