How can I pull the data next to a name from a website in VBA?

**max3732** · 04-01-2010, 10:30 PM

I have the program so that it logs on to a website and then loads a page that displays a card balance. When I look at the source code on the page it says "<TD><SPAN id=ctl00_ContentPlaceHolder1_ctl00_rptrHistory_ctl01_balance>$25.00</SPAN></TD>

How can I tell VBA to find whatever dollar amount is in the area where $25 is now and import it to a cell in excel? I don't know how to refer to that space in the html code.

**JeanRage** · 04-02-2010, 03:27 AM

Hi,

Have you picked which way to go : the web query route or the HTML object route ...
Posting your actual code would certainly help ...

**max3732** · 04-02-2010, 05:53 PM

Originally Posted by JeanRage

Hi,

Have you picked which way to go : the web query route or the HTML object route ...
Posting your actual code would certainly help ...

I'm not sure what you mean. This is the relevant piece of the code. H
D

Please Login or Register  to view this content.

**royUK** · 04-03-2010, 02:44 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**royUK** · 04-03-2010, 02:47 AM

https indicates a secure site, I doubt if you will be able to access any data without the relevant log in.

Why would you want to do this?

**max3732** · 04-06-2010, 10:29 AM

Originally Posted by royUK

https indicates a secure site, I doubt if you will be able to access any data without the relevant log in.

Why would you want to do this?

I am trying to automate a tedious process I do monthly. I have the logon but didn't want to post it online. I'm sorry for not making the code clearer in the post. Once I'm logged on I can see the data, but just don't know how to learn how to download it back into excel