Web Access

[HelpEachOther]

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!

 

[Guest]

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.

 

[Kathy Wright]

KAM
Thank you ery much for your quick response and help. I will try it and
let you know the results.

 

[Knut]

Data > Get external data > New Webquery (or sth like that, dont have excel
on hand right now). You may record a macro whwn you do this and study the
code generated.

hth
knut