visual basic code with online powerpoint

[sm]

I am currently using PPT 2000 and have used the visual basic editor to
expand the functionality for a presentation. The problem arises when trying
to view the presentation online. It is ok if I keep it as powerpoint,
though I believe this requires the person viewing to have the powerpoint
application on their machine? But if I use "Save as Web page" the visual
basic procedures don't seem to work. Is this problem remedied if I upgrade
to PPT 2003 (though I can't see any reference to this on the Microsoft
website) or do I need to use the script editor and program it as though it
were a normal web page? Or can I assume that a person is OK viewing it as a
standard .ppt presentation with or without the powerpoint application?



Many thanks for any help.



Simon Miller

 

[Chirag]

If the functionality you require can be obtained by using VBA (visual basic
code) only, then you require full PowerPoint to run it. When you publish it
to the web, the visual basic code would vanish. You can write scripting code
as if it were a normal webpage but you cannot use automation to access
PowerPoint objects. The free PowerPoint Viewer 2003 does not support VBA.

- Chirag

PowerShow - View multiple shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

 

[sm]

Thanks for this. Can I just clarify the point about having powerPoint to
view a presentation with VBA. When it is viewed through a browser still as
a powerpoint file, is it dependant on the powerpoint application being
accessed on a particular users machine or is there some kind of plug-in in
the browser which is viewing it - similar to the shockwave flash plug-in.
If not, is there any intention to develop such a plug-in or is it the
intention of Microsoft to use the viewer to achieve the same thing.

Thanks once again,

Simon

 

[Steve Rindsberg]

Thanks for this. Can I just clarify the point about having powerPoint to
view a presentation with VBA. When it is viewed through a browser still as
a powerpoint file, is it dependant on the powerpoint application being
accessed on a particular users machine or is there some kind of plug-in in
the browser which is viewing it - similar to the shockwave flash plug-in.

With default registry settings:

- If the user has the full PowerPoint, then that's what will play the PPT file.
- If they have just the viewer, then the viewer will play the PPT file.

If PowerPoint plays the file and IF the user's security settings permit it,
then the VBA macros will work. If the viewer plays the file, no VBA will work.

If not, is there any intention to develop such a plug-in or is it the
intention of Microsoft to use the viewer to achieve the same thing.

I'm not sure what type of plug-in you mean. One to make VBA available in the
viewer? MS doesn't share its strategies with us, but I'd be willing to bet
that holding your breath while you wait wouldn't be a healthy choice. ;-)