Click here to Skip to main content
15,944,136 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
A1 Cell in Excel address had Web Site URL, how to Assign that URL to Button VBA MACRO
when click the button web site will open, and how to assign that URL in Variable. 
in that button already had Code. when click the button two tasks will RUN
it means first on Opne WebSite and 2nd in and get the website Data.


What I have tried:

sub OpenURL()
	Dim aA_URL As String
    range("A1")=aA_URL = "abc.com"
    Dim aA_table As QueryTable
	End Sub
Posted
Updated 2-May-23 1:20am

1 solution

To follow the hyperlink just use
VB
ThisWorkbook.Sheets(1).Range("A1").Hyperlinks(1).Follow

Edit: I've just re-read your question and realised you want to get website data as well. That will rather depend on the site - the technique you need to search for is "VBA Web scraping" and that will get you plenty of examples
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900