View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Open Browser Maximized

No trouble.
If you don't have it yet download this:
http://www.allapi.net/agnet/apiguide.shtml
Helps me out all the time.

RBS

"Stephen Newman" wrote in message
...
Thanks so much RB. Exactly what I was looking for. Worked perfectly.

On Sat, 15 Apr 2006 15:25:48 +0100, "RB Smissaert"
wrote:

This might be a better way as it will take the default browser, which
may not be IE:

Option Explicit
Private Declare Function ShellExecute _
Lib "shell32.dll" _
Alias "ShellExecuteA" _
(ByVal hwnd As Long, _
ByVal lpOperation As String, _
ByVal lpFile As String, _
ByVal lpParameters As String, _
ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long

Sub ShowBrowserMaximized()

Dim strURL As String

strURL = "http://www.google.co.uk/"
ShellExecute 0, "open", strURL, vbNullString, vbNullString, 3

End Sub


RBS