MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need a VBA code to run a web query faster

  Asked By: Diana    Date: Dec 16    Category: MS Office    Views: 3393

This is for the first time I am posting a query.
Actually I am not good in VBA/Macro coding, But some how I have made
a macro for running a web query at my office.Its working fine except
the speed of downloading the details.
About Website : Web site(actually Intranet site) contains details
of our clients(almost 2000 clients). On daily basis we need to get
onto the site to fetch details of some of the clients.Its just like
a form where details of the client gets updated within 4-5 seconds
after clicking the name in the list.At the end of the URL, it
contains some unique number for the client.

My code is working fine to pull the data on excel, but it takes
almost same time as it takes to view details on web site(after
clicking the client name).I want to reduce the download time.So that
we dont have to visit the website again & again.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Need a VBA code to run a web query faster Or get search suggestion and latest updates.