VBA code to
 

Windows 2000/Excel 2000

I am automating some reports in Excel. These reports
access data from a data cube located on a server. We have
a third party .xla that manages the process.

I have several files I am updating, but the third
party .xla has a 'message' box that pops up at the
completion of one of the tasks that requires the selection
of 'OK' in order to continue.

I would like to either disable the feature, or , use code
to select 'OK' for any messages that require the selection
of 'OK'

I have tried
With Application
.DisplayAlerts = False
End With
but of course that does not work for this type of message
box.

Thanks in advance...

- - TB - -

VBA code to
 

That messagebox was hardcoded in the code of the add-in you mentioned. You won't be able to disable that. You may contact the author of that add-in to change that or if you have access to the source code of that add-in, you may ask someone to change that for you. It should be very simple.

VBA code to
 

I tend to agree with Edwin, but you may want to take a look at this
link. I haven't tried PTFB with Excel message boxes, but I've used it
successfully with other applications.

http://www.bobos.demon.co.uk/par/PTFB.htm

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Windows 2000/Excel 2000

I am automating some reports in Excel. These reports
access data from a data cube located on a server. We have
a third party .xla that manages the process.

I have several files I am updating, but the third
party .xla has a 'message' box that pops up at the
completion of one of the tasks that requires the selection
of 'OK' in order to continue.

I would like to either disable the feature, or , use code
to select 'OK' for any messages that require the selection
of 'OK'

I have tried
With Application
.DisplayAlerts = False
End With
but of course that does not work for this type of message
box.

Thanks in advance...

- - TB - -

VBA code to
 

Thanks for the follow-up. I figured the message box would
be 'hard coded', but thought worth asking....

As for your PTFB suggestion, it worked like a charm! I'm
not wild about going outside of VBA for this function, but
it solved the issue. Thanks.
-----Original Message-----
I tend to agree with Edwin, but you may want to take a
look at this
link. I haven't tried PTFB with Excel message boxes, but
I've used it
successfully with other applications.

http://www.bobos.demon.co.uk/par/PTFB.htm

HTH
Paul
----------------------------------------------------------
----------------------------------------------------
Be advised to back up your WorkBook before attempting to
make changes.
----------------------------------------------------------
----------------------------------------------------

Windows 2000/Excel 2000

I am automating some reports in Excel. These reports
access data from a data cube located on a server. We
have
a third party .xla that manages the process.

I have several files I am updating, but the third
party .xla has a 'message' box that pops up at the
completion of one of the tasks that requires the
selection
of 'OK' in order to continue.

I would like to either disable the feature, or , use
code
to select 'OK' for any messages that require the
selection
of 'OK'

I have tried
With Application
.DisplayAlerts = False
End With
but of course that does not work for this type of
message
box.

Thanks in advance...

- - TB - -


.