Beginner

[BigUglyGuy]

I'm a raw rookie beginner. I need code to open a website from excel using vba?

[YasserKhalil]

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

[BigUglyGuy]

Thank you thank you thank you!!!!!! U R A STAR, Thank you!

[YasserKhalil]

Remember I'm just a beginner like you

[BigUglyGuy]

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???

[BigUglyGuy]

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.

[BigUglyGuy]

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