|
 |
access thread: FW: Open HTML Page
Message #1 by "George Oro" <george@c...> on Wed, 19 Mar 2003 19:56:39 +0400
|
|
It seems it doesn't gone...
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Wednesday, March 19, 2003 6:51 PM
To: Access Help
Subject: Open HTML Page
How to open a Local HTML page or a Web Site using VBA?
I guess this is simple but I cannot figure-out. Any help would be highly
appreciated....
TIA,
George
Message #2 by "Enzo Zaragoza" <enzaux@g...> on Thu, 20 Mar 2003 09:12:39 +0800
|
|
Kabayang George,
I got this from the vb forum from Peter Kipe. Though this was intended to open a word document
may be you can make use of this because it would have Windows open the document with the
document's associated app, rather than shelling Word and passing the
name of the file to be opened. That way, if Word were not installed, there
wouldn't have a problem...
-----------------------------------
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
Private Sub mnuHelpDocumentation_Click()
Dim strFileName As String
Dim lngReturn As String
' get the fully-qualified document name
strFileName = App.Path & "\documentation.doc"
' have it shown by its associated app
lngReturn = ShellExecute( _
Me.hWnd, _
"OPEN", _
strFileName, _
"", _
"", _
vbNormalFocus)
----------------------------------
enzo c",)
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Wednesday, March 19, 2003 11:57 PM
To: Access
Subject: [access] FW: Open HTML Page
It seems it doesn't gone...
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Wednesday, March 19, 2003 6:51 PM
To: Access Help
Subject: Open HTML Page
How to open a Local HTML page or a Web Site using VBA?
I guess this is simple but I cannot figure-out. Any help would be highly
appreciated....
TIA,
George
Message #3 by "George Oro" <george@c...> on Thu, 20 Mar 2003 10:40:53 +0400
|
|
Yo Enzo,
Actually after I send my post, I tried to open my local html using the logic how to open Word/Excel file and its working. I just add
one line to my HTML to call open my asp page on the web automatically.
Thanks anyway...
GERA NA,
GEORGE
> -----Original Message-----
> From: Enzo Zaragoza [mailto:enzaux@g...]
> Sent: Thursday, March 20, 2003 5:13 AM
> To: Access
> Subject: [access] RE: FW: Open HTML Page
>
>
>
> Kabayang George,
>
> I got this from the vb forum from Peter Kipe. Though this was intended to open a word document
> may be you can make use of this because it would have Windows open the document with the
> document's associated app, rather than shelling Word and passing the
> name of the file to be opened. That way, if Word were not installed, there
> wouldn't have a problem...
>
> -----------------------------------
> 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
>
> Private Sub mnuHelpDocumentation_Click()
> Dim strFileName As String
> Dim lngReturn As String
>
> ' get the fully-qualified document name
> strFileName = App.Path & "\documentation.doc"
>
> ' have it shown by its associated app
> lngReturn = ShellExecute( _
> Me.hWnd, _
> "OPEN", _
> strFileName, _
> "", _
> "", _
> vbNormalFocus)
> ----------------------------------
>
>
> enzo c",)
>
>
>
> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Wednesday, March 19, 2003 11:57 PM
> To: Access
> Subject: [access] FW: Open HTML Page
>
>
> It seems it doesn't gone...
>
> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Wednesday, March 19, 2003 6:51 PM
> To: Access Help
> Subject: Open HTML Page
>
>
> How to open a Local HTML page or a Web Site using VBA?
>
> I guess this is simple but I cannot figure-out. Any help would be highly
> appreciated....
>
>
> TIA,
> George
>
>
>
>
>
>
>
Message #4 by "Enzo Zaragoza" <enzaux@g...> on Thu, 20 Mar 2003 15:32:33 +0800
|
|
okies no problem ;)
oo nga gyera na,
enzo
P.S.
http://www.cnn.com/SPECIALS/2003/iraq/forces/weapons/index.html <<< US-Iraq arsenal comparison
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Thursday, March 20, 2003 2:41 PM
To: Access
Subject: [access] FW: Open HTML Page
Yo Enzo,
Actually after I send my post, I tried to open my local html using the logic how to open Word/Excel file and its working. I just
add
one line to my HTML to call open my asp page on the web automatically.
Thanks anyway...
GERA NA,
GEORGE
> -----Original Message-----
> From: Enzo Zaragoza [mailto:enzaux@g...]
> Sent: Thursday, March 20, 2003 5:13 AM
> To: Access
> Subject: [access] RE: FW: Open HTML Page
>
>
>
> Kabayang George,
>
> I got this from the vb forum from Peter Kipe. Though this was intended to open a word document
> may be you can make use of this because it would have Windows open the document with the
> document's associated app, rather than shelling Word and passing the
> name of the file to be opened. That way, if Word were not installed, there
> wouldn't have a problem...
>
> -----------------------------------
> 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
>
> Private Sub mnuHelpDocumentation_Click()
> Dim strFileName As String
> Dim lngReturn As String
>
> ' get the fully-qualified document name
> strFileName = App.Path & "\documentation.doc"
>
> ' have it shown by its associated app
> lngReturn = ShellExecute( _
> Me.hWnd, _
> "OPEN", _
> strFileName, _
> "", _
> "", _
> vbNormalFocus)
> ----------------------------------
>
>
> enzo c",)
>
>
>
> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Wednesday, March 19, 2003 11:57 PM
> To: Access
> Subject: [access] FW: Open HTML Page
>
>
> It seems it doesn't gone...
>
> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Wednesday, March 19, 2003 6:51 PM
> To: Access Help
> Subject: Open HTML Page
>
>
> How to open a Local HTML page or a Web Site using VBA?
>
> I guess this is simple but I cannot figure-out. Any help would be highly
> appreciated....
>
>
> TIA,
> George
>
>
>
>
>
>
>
|
|
|
View Cart
