I have found some code in another database I worked on and used the following code and it worked
Application.FollowHyperlink "W:\DATA MANAGEMENT SERVICES\Database Mappings and Documents\PeopleSoft Datawarehouse\Html files\Unmatched Titles Process.htm"
Jim Wagner
On Monday, March 24, 2014 12:32 PM, "luvmymelody@yahoo.com" <luvmymelody@yahoo.com> wrote:
Hello,
I have added the following code to open a html page located in a network folder. The html page is a link to an online documentation for our database. The code opens internet explorer but not the html file.
Is there something that I am missing?
Thank You for your help
Jim Wagner
response = MsgBox("The query named qryCurrentTitlesUnmatched behind this message box" _
& "is the Title that could be a title not found in the Performance Evaluations. Do you want to see how this query works, Click Yes", vbYesNoCancel, "Unmatched query")
If response = vbYes Then
Dim ProjPath
ProjPath = "W:\DATA MANAGEMENT SERVICES\Database Mappings and Documents\PeopleSoft Datawarehouse\Html files\Unmatched Titles Process.htm" '& Me.PolicyNo.Value
Shell "C:\Program Files\Internet Explorer\iexplore.exe """ & ProjPath & "", vbNormalFocus
End If
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar