G
gary
Using VBA, I need to start an Internet Explorer browser from Excel. The
below code does this but I am not able to control the vertical scroll bars
from my VBA application. How do I do this so I can poisition the scroll bar
where I want it displayed?
Here is the vb code that works:
Set Ie = CreateObject("InternetExplorer.Application")
Ie.AddressBar = False
Ie.MenuBar = False
Ie.Toolbar = False
Ie.Width = 600
Ie.Height = 750
Ie.Left = 0
Ie.Top = 0
Ie.navigate "www.yahoo.com"
Ie.resizable = True
Ie.Visible = True
Ie.document.vscrollbar.value = 200 ' THIS DOES NOT WORK !!
Thanks,
Gary
below code does this but I am not able to control the vertical scroll bars
from my VBA application. How do I do this so I can poisition the scroll bar
where I want it displayed?
Here is the vb code that works:
Set Ie = CreateObject("InternetExplorer.Application")
Ie.AddressBar = False
Ie.MenuBar = False
Ie.Toolbar = False
Ie.Width = 600
Ie.Height = 750
Ie.Left = 0
Ie.Top = 0
Ie.navigate "www.yahoo.com"
Ie.resizable = True
Ie.Visible = True
Ie.document.vscrollbar.value = 200 ' THIS DOES NOT WORK !!
Thanks,
Gary