Please Help !!!
I have a powerpoint presentation that has a command button on it with a vba macro. I plan to publish this file on LMS so that clients can use it as a learning activity. When they get to the last page they will be instructed to click on the command button and that in turn will take them to a specific website where the can continue their training. The macro searches for the currently active Internet Explorer window that has the word "SUMTOTAL" in its title and then opens into that IE window the specified webpage. In my example I am calling the webpage "www.google.ca"
My problem is, when I publish this using the Powerpoint addon Articulate the button becomes inactive and will not execute the macro in the webpage window. Can anyone tell me how to get around this problem? Can VBA macros run on the internet or are they incompatible with HTML code ? How can I publish this on the internet in Show Mode so that the command button and code will work ? Thank you.
My code looks like this:
Private Sub CommandButton2_Click()
'loop through each window
For Each wd In CreateObject("Shell.Application").Windows
If wd = "Windows Internet Explorer" Then
If InStr(UCase(wd.Document.Title), "SUMTOTAL") <> 0 Then
wd.Navigate "rivate Sub CommandButton2_Click()
'loop through each window
For Each wd In CreateObject("Shell.Application").Windows
If wd = "Windows Internet Explorer" Then
If InStr(UCase(wd.Document.Title), "SUMTOTAL") <> 0 Then
wd.Navigate "http://www.google.ca"
Exit For
End If
End If
Next wd
End Sub
Bookmarks