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.