MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

web browser control problem

  Asked By: Don    Date: Mar 02    Category: MS Office    Views: 629

My program (VBA under Excel) uses Microsoft's web browser control to
navigate and get data from a website.
There are 5 active copies of this program, each running on a
different computer, connected through the same company network to the
The program runs perfectly on one computer. The web browser fails,
however, on three of the other computers, and fails intermittently on
the fourth.
I have ruled out site failure, as on all computers there is no
problem getting the data using MSIE (checked at virtually the same
time the program tried it automatically).
Assuming it's the same program running on all computers (it is), this
anomaly may be attributed to differing Windows version, differing
Excel versions, or some difference in the network connection.
Any ideas what could be the reason, and how the problem could be



2 Answers Found

Answer #1    Answered By: Minal Nayak     Answered On: Mar 02

Have you checked for missing References on the failing computers? From
the VBE - Tools, References. If there are not any missing references
can you debug the code on those computers without failure? If you still
don't have a solution, maybe you could post the code so someone could
test for you.

Answer #2    Answered By: Haru Tanaka     Answered On: Mar 02

I am not an expert in this field, but with a bit more info, I am sure
someone will be able to help you.

In what version  of Excel did you develop your VBA code?

List the Excel versions  on the five computers, including which ones work
or not.

Did you have to include another dll in VBE while developing the code to
access the browser? If so, was this activated on the other PC's?

Windows version per computer, again which ones are working or not.

Any other special software, e.g. custom firewalls, or user access rights
on the internet?

Didn't find what you were looking for? Find more on web browser control problem Or get search suggestion and latest updates.