VBA-EXCEL :: After updating to Office 2003 Excel acts weird

[Edgardo Sepulveda]

Hi, i had a little application that opened web pages with Excel and it was
working fine, until i upgraded to Office 2003 and then suddently my
application is throwing pop ups telling me that certaing URL was not found.
Before i had a "On error resume next" that took care of those, but now it is
giving me these errors and the application is supposed to work alone, so one
has to touch anything and it will continue to work... as it need a click on
the "OK" button, my application now waits forever.

This is the way im opening the url

On error resume next
Set xl = CreateObject("Excel.Application")
Set xwb = xl.Workbooks.Open(url)


Any suggestions? how can i kill my bug? there is no "Try Catch" on VBA or it
is? any idea?

im using a timer to repeat the execution forever that's why this popup is
killing the whole idea.


Thanks in advance for your help

Edgardo

 

[Don Guillett]

Probably has to do with references in visual basic. Check tools>references.

 

[Edgardo Sepulveda]

The thing is that im using Access so i really dont have references in a
project i just create an Excel Object and use it

 

[onedaywhen]

What about:

xl.DisplayAlerts = False

 

[Edgardo Sepulveda]

Thanks.. it seems a pretty good suggestion, i havent used already, let me
try it and then i'll tell you how it responds..


Thanks a lot

Edgardo