How do I code VBA to return information from a web site to an excel workbook

  • Thread starter Thread starter Richard Mogy
  • Start date Start date
R

Richard Mogy

Hi all,
How do I code VBA to return information from a web site to an excel
workbook.

I tried to record a macro, but it didn't return any code.

Thank you in advance.

Don't have a a specific, but general project in mind.

Richard Mogy
 
did you try <data-get externaldata> and create a newweb query.
fill in the particulars in the newwebquery window. If successful everytime
you can refresh.
this avoids VBA.
see help in spreadsheet giving keywords <get external data>
 
Richard,
Data>Get External Data>New Web Query, recording a macro if required.

NickHK
 
Thank you.
R.VENKATARAMAN said:
did you try <data-get externaldata> and create a newweb query.
fill in the particulars in the newwebquery window. If successful
everytime
you can refresh.
this avoids VBA.
see help in spreadsheet giving keywords <get external data>
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pulling data from one workbook to another one using VBA 0
how to query my web site from VBA and return a value to VBA 2
How to bypass password when pasting FROM a protected workbook 3
How to split an excel workbook in code and data 2
Open a word mail-merge document from Excel VBA 1
How to append data from different sheet and different workbook? 2
Run code from another workbook 7
how to get the vba code behind an excel sheet 0

Back
Top