Re: save powerpoint to two locations?
- From: Steve Rindsberg <abuse@xxxxxxxxxxxxx>
- Date: Sat, 21 Jun 2008 22:38:48 EDT
In article <BC9A9C38-2F32-4E0A-8490-8B1B82881748@xxxxxxxxxxxxx>, DrMarsha wrote:
Will this work just like the Word macro??? (by clicking on the separately
created icon for the word it saves to BOTH the original location and the
designed "backup" location?) In other words, do you have to use that new
macro by clicking only once, or do you have to click twice on two different
icons?
In that this one creates no icons, you'd have to manually run the macro or otherwise
figure out how to launch it. But it'll save to the original location and to
another.
Also, do you know if there is also something available for Excel?
No, but it shouldn't be too hard to adapt either this or Graham's Word macro to work
with Excel.
"Steve Rindsberg" wrote:
Something like this should do the job in PPT. It assumes that you've saved the
presentation once to begin with. If that's not a valid assumption, you'd need
more code to test for an unsaved presentation and force the user to save and
give the presentation a name/location.
Hint: if the ActivePresentation's .Name and .Fullname properties are identical,
it hasn't been saved. Once it's saved, the .Fullname will include the entire
path.
Sub SaveTwice()
' Saves the presentation once to its current location and
' once to a "backup" location
Dim sBackupPath As String
' EDIT THIS
' Plug in any backup path you'd like
' Be sure to end the path with a backslash \
' (or colon if adapting this to Mac)
sBackupPath = "C:\TEMP\"
With ActivePresentation
' Save it normally
.Save
' Save a copy to your backup location
Call .SaveCopyAs(sBackupPath & .Name)
End With
End Sub
In article <0C49CE28-00C8-409A-8852-0F837397949A@xxxxxxxxxxxxx>, DrMarsha wrote:
Can you save PowerPoint to locations at the same time using VBA/Macros as you
are able to with word? (http://www.gmayor.com/automatically_backup.htm) I
tried copying and pasting the macros from that website site and get an error
when trying to run it.
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
.
- References:
- Re: save powerpoint to two locations?
- From: Steve Rindsberg
- Re: save powerpoint to two locations?
- From: DrMarsha
- Re: save powerpoint to two locations?
- Prev by Date: Re: Can't do a chart link-to PPT from Excel
- Next by Date: Re: Can't do a chart link-to PPT from Excel
- Previous by thread: Re: save powerpoint to two locations?
- Next by thread: Re: Displaying lyrics over motion loop
- Index(es):
Relevant Pages
|