P
Pete
Hi all (AB)
I am on Excel 2002 SP3 and Windows Vista Home Premium
The webpage pushed out by Excel has the default white background
Is there any way of making the web page have a black background (without
changing the default setting it in the Browser itself)?
Function OpenBrowser(tmpURL)
'tmpURL is the local address where the page resides
'To open a web page in a separate window
Set Browser = CreateObject("InternetExplorer.Application")
Browser.Navigate (tmpURL)
'****************
'I tried these two lines but get errors in both cases:
Browser.BackColor.SchemeColor = 0
Browser.Background.Color = 0
'****************
Browser.Addressbar = False
Browser.StatusBar = False
Browser.Toolbar = False
Browser.MenuBar = False
Browser.Visible = True
'Browser.fullscreen = True
Browser.Resizable = True
End Function
Sub SelectAtendees()
Dim WebPageDirectory As String
WebPageDirectory = Range("My_Directory") & "\page.htm"
OpenBrowser WebPageDirectory
End sub
I am on Excel 2002 SP3 and Windows Vista Home Premium
The webpage pushed out by Excel has the default white background
Is there any way of making the web page have a black background (without
changing the default setting it in the Browser itself)?
Function OpenBrowser(tmpURL)
'tmpURL is the local address where the page resides
'To open a web page in a separate window
Set Browser = CreateObject("InternetExplorer.Application")
Browser.Navigate (tmpURL)
'****************
'I tried these two lines but get errors in both cases:
Browser.BackColor.SchemeColor = 0
Browser.Background.Color = 0
'****************
Browser.Addressbar = False
Browser.StatusBar = False
Browser.Toolbar = False
Browser.MenuBar = False
Browser.Visible = True
'Browser.fullscreen = True
Browser.Resizable = True
End Function
Sub SelectAtendees()
Dim WebPageDirectory As String
WebPageDirectory = Range("My_Directory") & "\page.htm"
OpenBrowser WebPageDirectory
End sub