Try giving the site URL in a File name in Excel like opening a new excel file.

Should open the whole page in Excel. You can go to your desire cells and
work further to generate your desire data set.

--
KAM Trivedi
Sr. Developer
BBDO Canada Inc.


"HelpEachOther" wrote:

I am new to this group. I hope that I can provide help to and also get
help from you.

I have been using VB.NET to gather data from the company's intranet to
get data and generate reports. I have just got a new project which may
need to access web from Excel using VBA.

Do you know if VBA allows me to access a web page (similar to
HttpWebRequest & WebResponse in VB.net) and download the data from the
web page? Please let me know. Thank you very much for your help!