PDA

View Full Version : Beginner



BigUglyGuy
06-29-2010, 03:00 PM
I'm a raw rookie beginner. :help I need code to open a website from excel using vba?

YasserKhalil
06-29-2010, 03:15 PM
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
06-29-2010, 03:22 PM
Thank you thank you thank you!!!!!! U R A STAR, Thank you! :bow:

YasserKhalil
06-29-2010, 03:25 PM
Remember I'm just a beginner like you

BigUglyGuy
06-29-2010, 03:27 PM
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
06-29-2010, 03:28 PM
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
06-29-2010, 03:54 PM
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