application.displayalerts

  • Thread starter Thread starter Steve J
  • Start date Start date
S

Steve J

When using activeworkbook.save I have come across a problem that has got me
confused.

If I have "application.displayalerts" set to false the workbook does not
save (on XL97) but works fine on 2003.

How can I rectify this?
 
There must be more to the story. The text of the code should have no affect
on whether the workbook saves as one version or another. It is remotely
possible that xl97 might have a format problem with the alert display set to
false, but it is the first I have heard of it.
 
There must be more to the story. The text of the code should have no
affect on whether the workbook saves as one version or another. It is
remotely possible that xl97 might have a format problem with the alert
display set to false, but it is the first I have heard of it.

There must be more to the story which is what i need to track down. So
any ideas on what to check?
 
Try running the code with DisplayAlerts = True

See what alert appears, then report back. It could be a permissions thing, a file already exists... could be many things, but the alert content will help!

Cheers,
Rob
 

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


Back
Top