Loose forms made in VBA when publishing to web

  • Thread starter Thread starter FireGeek
  • Start date Start date
F

FireGeek

Does anyone know how to retain the vba code (especially any forms
created through VBA) when publishing a presentation to the web?

FireGeek
 
FireGeek said:
Does anyone know how to retain the vba code (especially any forms
created through VBA) when publishing a presentation to the web?
Click to expand...

What are you trying to make happen FireGreek? And can we call you Icarus? <g>

IIRC, publishing from 2002 and up to HTML should retain the VBA in the original
presentation when you open the saved HTML back up into PPT.

Either that's not happening OR that's not what you're doing.

So ... what're you doing and what's happening (or not) when you do it?
 
Steve,

I have 2 buttons on a slide - Yes and No. Action Settings point to a
Macro written in VBA that will show a form (Added/Designed in VBA) that
shows a picture and says something to the effect of "Good Answer" or
"Bad Answer". This code has been compiled successfully.

Saving the presentation as .ppt and running the slide show all work
just fine. Click on an answer button and I get the appropriate form to
show as a response.

The goal is to ultimately save this presentation as HTML. This is
actually a company training that needs to be uploaded to a server and
viewed over the web. I Save As... HTML and then attempt to test the
buttons. Upon clicking on either one, nothing happens. I also changed
the code and remarked out the showing of the form and changed it to a
simple message box. Save as .ppt and then as HTML. Try again and upon
clicking on the changed button, I get no message box.

Hope this is clearer for you. (BTW - call me whatever you desire - I
don't care much.)

FireGeek
 
The goal is to ultimately save this presentation as HTML. This is
actually a company training that needs to be uploaded to a server and
viewed over the web. I Save As... HTML and then attempt to test the
buttons. Upon clicking on either one, nothing happens. I also changed
the code and remarked out the showing of the form and changed it to a
simple message box. Save as .ppt and then as HTML. Try again and upon
clicking on the changed button, I get no message box.

Hope this is clearer for you.
Click to expand...

Much, thanks. That's the good news. The bad news is that what you want to do
isn't going to happen, at least not automatically out of PPT.

VBA in a PPT file only works when the PPT is open in PowerPoint itself, not
from a browser or the free viewer. It makes sense, really ... most of what you
do in VBA within PPT is manipulate PPT shapes and such. With no PPT there,
there's nothing to manipulate, no app to support the object model your code
relies on.

If the people who'll be using the presentation have PowerPoint, consider
posting the PPT file itself rather than the HTML version.
(BTW - call me whatever you desire - I
don't care much.)

FireGeek
Click to expand...

Oops. I read "Greek" for "Geek". Nevermind.
 
Back
Top