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.


"Steve J" <(E-Mail Removed)> wrote in message
news:Xns9CDA94E9989ACmrjoinesatgooglemail@69.16.176.253...
> 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?

"JLGWhiz" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> 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.
>
>
> "Steve J" <(E-Mail Removed)> wrote in message
> news:Xns9CDA94E9989ACmrjoinesatgooglemail@69.16.176.253...
>> 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 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


Steve J wrote:
> "JLGWhiz" <(E-Mail Removed)> wrote in
> news:(E-Mail Removed):
>
>> 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.
>>
>>
>> "Steve J" <(E-Mail Removed)> wrote in message
>> news:Xns9CDA94E9989ACmrjoinesatgooglemail@69.16.176.253...
>>> 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 which is what i need to track down. So
> any ideas on what to check?