Replies

Lenny,

Thanks for your succinct answer, however, I already know how to do this type of link and this type of link would require us to zip a directory that includes the presentation and linked files. The objective is to have all files embedded in PowerPoint. Currently, there are MS Word and Excel files that are active and embedded objects in the PPT show.

Since, this presentation is being emailed around the world to various government IT managers, we are trying to eliminate the need to zip directories of files that are associated with the presentation and make all the documents inherent to the PPT. The less moving parts and items there are to deal with, the less confusion and chance of error. I do have some very basic Visual Basic experience and am willing to give it a try. I just know that PowerPoint is a very different beast in the VB arena than the other Office programs and am seeking advice as how to get a macro started to make the object click-able if it is possible.

Thanks again, I will keep my fingers crossed.

Open an Excel worksheet.
Label your columns:
Today

My best way to turn on and off the ‘Snap to Grid’, is to load the drawing toolbar from the ‘View’ drop down menu; Toolbars; Drawing. On my system, the toolbar appears on the bottom of my monitor.

I am using PP2000 but the 97 version is very similar.
Now the Left Most button on the Drawing toolbar is labeled, “Draw”. Click that and ensure that it expands completely. The “Snap” item will take you to two enable/disable options, 1. Grid and 2. Shape.

If you deselect both the Grid and Shape, you will not snap to anything and you can precisely move or place objects on your slide.

Fred,

From what I understand, which is not much, the success of the macro to ppa process within PowerPoint is enabled thru the “save as” function. I know that the macro codes must first exist in a blank ppt file and that there is some sort of conversion that occurs when morphing the ppt to ppa. It appears to me that some inheritance issues are at play. I am not certain. I just know that this process works and I will have to obey Microsoft in the design and implementation of ppa’s.

Maybe other Loungers or moderators have the answer you seek.

Fred,
Microsoft article Q222737: http://support.microsoft.com/default.aspx?…b;EN-US;q222737%5B/url%5D has the Add-in procedures. The Auto_Open and Auto_Close code you see will either add or remove the Add-in from your drop down tool bar. This is primarily used during the loading and unloading of an Add-in. For example, Unload specifically contains the clean up code to remove the menu item.

I recommend you read the Microsoft article on PowerPoint Add-ins from the link above.
Does this shed more light on the topic for you? or do you have more questions?

Fred,
When I made the .ppa and used the ‘add-in’ feature under tools, it made the .ppa available to all PowerPoint files I open. I recommend you copy/move the .ppa to the proper directory. My directory for a NT workstation is C:WINNTProfilesprofilenameApplication DataMicrosoftAddIns. After that, you should be able to load the .ppa once through PowerPoint and have it available to all presentations from that point on.

I have found no any other way to do this. I hope this answers you questions.

Jefferson and Sam,

Attached is the final NotesPurge PowerPoint Add-in. Here is the file location for a NT4 machine. I do not know where it would be for a Win98/Me/2K/XP install.
C:WINNTProfilesusernameApplication DataMicrosoftAddIns.

Wow! That’s great!!

I have a little VB background and was so confused trying to navigate the PowerPoint macro/vb modules. I am not strong with VB logic. The second code works excellent as a macro and cleans every speaker note from every slide.

I made the macro a PowerPoint Add-in and was successful at adding a new menu option to my PPT Tools menu titled “Purge Notes” and the code executed beautifully.

Thank you for your excellent reply, this has given me an inside look to PPT VB logic.
Below is the final VB module code for the PPA.
I hope others can use it as well
—————————————————–
Sub NotesPurge()
‘ Notes Purge Macro created 6/6/02 by jscher2000 in Woody’s Lounge @ http://www.wopr.com
‘This Sub NotesPurge is excellent as a macro in PPT, all by its self
Dim aSlide As Slide
For Each aSlide In ActivePresentation.Slides
aSlide.NotesPage.Shapes(2).TextFrame.TextRange.Text = vbNullString
Next

End Sub

Sub Auto_Open()
‘Auto Open added by Ryan Woolever, using modified Microsoft online support examples http://www.microsoft.com
‘This adds a toolbar command called Purge Notes when Loading a PP Add-in
Dim NewControl As CommandBarControl

‘ Store an object reference to a command bar.
Dim ToolsMenu As CommandBars

‘ Figure out where to place the menu choice.
Set ToolsMenu = Application.CommandBars

‘ Create the menu choice. The choice is created in the first
‘ position in the Tools menu.
Set NewControl = ToolsMenu(“Tools”).Controls.Add _
(Type:=msoControlButton, _
Before:=1)

‘ Name the command.
NewControl.Caption = “Purge Speaker Notes”

‘ Connect the menu choice to your macro. The OnAction property
‘ should be set to the name of your macro.
NewControl.OnAction = “NotesPurge”

End Sub

Sub Auto_Close()
‘Auto Close added by Ryan Woolever, modified Microsoft online support examples http://www.microsoft.com
‘
Dim oControl As CommandBarControl
Dim ToolsMenu As CommandBars

‘ Get an object reference to a command bar.
Set ToolsMenu = Application.CommandBars

‘ Loop through the commands on the tools menu.
For Each oControl In ToolsMenu(“Tools”).Controls

‘ Check to see whether the comand exists.
If oControl.Caption = “Purge Speaker Notes” Then

‘ Check to see whether action setting is set to NotesPurge.
If oControl.OnAction = “NotesPurge” Then

‘ Remove the command from the menu.
oControl.Delete

End If
End If

Next oControl

End Sub
—————————————————–

Stephen21,

As stated by Jscher2000, Small Business Edition doesn’t include PowerPoint, but I use Office 2000 Premium and it does include PowerPoint AND Small Business Tools AND Publisher AND PhotoDraw.

Hope this helps in your analysis.

Lucas,

I have encountered anomalies in viewing PowerPoint shows when either the Hard Drive is full or the RAM is insufficient. At that time, the available Hard Drive space on my machine was about 12% and the PowerPoint file was over 4MB.

I recommend you compare the available Hard Disk space and installed RAM on both machines. I hope the answer is that simple.

Try this.

PPT2000: PowerPoint Stops Responding When It Is Started (Q236589)]
http://support.microsoft.com/search/previe…b;en-us;Q236589%5B/url%5D

What, if any, error do you get?

Fafner,

I use PPT2000 regularly and have had this is the past. The ranges of file sizes that I work with go up to 12MB and sometimes higher. Usually, in the past, all I have had to do is shut down my computer for a few minutes and restart. That has corrected the problem for me. I believe that sometimes PPT does not release from memory until a reboot is accomplished, nothing I do to restore the program is successful.

Stuart,

I did some more looking that in just Google and discovered a web site called http://www.myfonts.com. I entered your “katrina” and found a “kat rina” and a “caterina”. This site had more hits for my entry of kat or katrina than any other site I visited over the past 30 minutes. I hope you find what you seek.

http://www.myfonts.com

In PowerPoint 2000, you can link the charts from a workbook by using functions embeded in the object slide layout. It has been awhile since I worked on the 97 version. I hope this will work for your.

You will need to change the slide layout to either a large object or object.
If you are unfamiliar with this, you are able to change the format of each slide from a bullet list to a movie clip slide and several in between. You can find this feature under the menu Format – Slide Layout. I would recommend you use either the large object or object with title layout. When you select either of these layouts, you will see a caption to “double click to add object” on your PowerPoint slide, do that double click and a dialogue box will prompt you for several things.
1. Create from:
a. New
1. Object Type

b. File (You should use this one)
1. Link (Definitely select this one)

2. Display as icon (do not select)

Browse to your Excel file and select it for use and press OK until you are back to your PP slide.
Now you will see your last active worksheet in that workbook displayed on your PP slide.
Double click your Excel worksheet and either create your chart or select the chart tab you want to display.
I recommend that you place the charts on their own worksheet not co-mingled on the data worksheet.

After you are finished with your chart making, Save & Exit from excel and you will notice that your changes did not seem to take effect.
Here’s the trick,
Right click and select ‘update link’ and Whalah!

Your chart now shows in PowerPoint and is linked. So, any changes you make and save to the workbook in the future will automatically update the charts and when you are finished, OPEN the PowerPoint and you will be prompted to updated the links. Select ‘Yes’ and then save your PP. You are now done.

One Workbook – One PowerPoint.
No More Copy, Paste, and Resize.