VBA code to

  • Thread starter Thread starter Tom B
  • Start date Start date
T

Tom B

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 - -
 
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.
 
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.
 
Back
Top