I'm a raw rookie beginner. I need code to open a website from excel using vba?
I'm a raw rookie beginner. I need code to open a website from excel using vba?
Try this Mr. Beginner
Sub LaunchSite() Dim newsite As Object Set newsite = CreateObject("InternetExplorer.application") newsite.Visible = True newsite.Navigate "http://www.VBAExpress.com" End Sub
Thank you thank you thank you!!!!!! U R A STAR, Thank you!
Remember I'm just a beginner like you
Ok I can open the website BUT: How do I just skip between excel and the website? Copy something on the website and then paste it on excel and then go back to the web site moving the curser copy something and then go back to excell pasting the info etc???
No Sir I disagree U R a Master! I have been battling for weeks just to get the code sorted that took you 5 minutes.
Ok 1 step at a time: How do I just skip between excel and the website?
This is the code I have for skipping between 2 sheets:
Sheets("Sheet1").Select
Range("A2").Select
Sheets("Sheet2").Select
Range("A2").Select