VBA reading URLs directly?? (http objects??)

thereuare

Board Regular
Joined
May 28, 2002
Messages
232
I'd like to have VBA read data directly from a URL (the URL basically shows a CSV file on the screen, in a spreadsheet format).

I asked somebody that does this in C++ how he does this and his response was that he uses http objects that MSFT provides in C++. He didn't know if something like this exists in VBA, so i'm asking here.

Does this exist in VBA, and if so, can somebody point me in the right direction so i can read up on it?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
I'm not sure, I would imagine you could it but,have you tried a webquery. Depends how your HTML page is formatted but webqueries are excellent for getting information from a webpage
 
Upvote 0
Here's a piece from the email i sent to the person i know will better explain my situation and the problem using the web query:

I've been using VBA to create a short program that will chart Point and Figure charts in an Excel spreadsheet, and have been
able to get it to work when reading from a CSV file. I would like to have the program read directly from Yahoo's historical data, but have been unable to EFFICIENTLY do so.

I am able to get it done by having a program
fetch the requested symbol via a web query, have the data automatically saved to a TXT file, open the file, format the data so the program can read it, then save and close the file as a CSV, and finally "execute" the program to chart. This works, but is very labor intensive for the computer and NOT very efficient.

Even if i can't manipulate the data to be read directly by the program, i can change the program to read the data in its existing format.

Any help would be appreciated, of course, feel free to ask add'l questions if you need to understand my situation better.

Thanks
 
Upvote 0

Forum statistics

Threads
1,223,493
Messages
6,172,618
Members
452,466
Latest member
Lynlindsay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top