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!

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!

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


*** Sent via Developersdex http://www.developersdex.com ***

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
"Kathy Wright" skrev i melding
...
KAM
Thank you ery much for your quick response and help. I will try it and
let you know the results. :)


*** Sent via Developersdex http://www.developersdex.com ***