Hi,
There is a decision to make. Applescript vs VBA
AppleScript:
Pro - System Wide. Once you learn AppleScript you'll be able to script lots
of other Mac applications. AppleScript will continue to be supported in
Office 2008 when it comes out
Con - You really need to know Microsoft's VBA to get at the Excel and
PowerPoint object models. Applescript manipulates the Excel and PowerPoint
object models using Microsoft's Object Linking and Embedding (OLE)
technology. Applescript is Mac only.
Visual Basic for Applications (VBA)
Pro - Largely cross-platform Mac and PC. Probably the most widely used
programming language in the world. Built into Office 2004 on the Mac.
There's a huge wealth of resources since it's been around a long time.
Con - VBA's is at the end of its life. It goes away in Office 2008 on the
Mac and the proposition is that it will also go away eventually on the PC
side. Mac VBA is version 5.
A place to get started with Excel VBA
http://www.mcgimpsey.com/excel/index.html#usingvba
A place to get started with PowerPoint VBA
http://pptfaq.com/FAQ00033.htm
A place to get started with applescript
http://developer.apple.com/applescript/
To start the VBA editor on a mac go to View > Toolbars > Visual basic and
click the Visual Basic Editor button on the toolbar.
If you use VBA you will be using OLE to run PowerPoint from Excel. So when
you are programming, write your code in Excel's visual basic editor and use
OLE to run PowerPoint via VBA. You'll still need to use the VBA editor
inside PowerPoint to get at the PowerPoint VBA help, object model, and
syntax. Office 2004 can edit, compile and execute VBA. Office 2008 will
not.
If you use AppleScript you will use AppleScripts editor (comes with Mac OS
in the Applications folder) and the AppleScript compiler.
Is this too much or too little information?
Thanks.
-Jim Gordon
Mac MVP
Quoting from "Jack" <
[email protected]>, in article
(e-mail address removed), on [DATE:
On Jun 1, 10:24 pm, Jim Gordon MVP <
[email protected]>
wrote:
Hello Jack,
I would approach this problem differently.
May I assume that you have a lot of presentations and that they are
organized into some sort of file and folder hierarchy?
If the answer is "yes" then here's another approach.
Use a utility that can make lists of the file paths to each of the
presentations. I didn't look deeply into this, but perhaps Smith-Micro's
PrintIt can do this. Look for other stuff, though, that might be designed
for this specific
task.
http://store.digitalriver.com/servlet/ControllerServlet?Action=Displa..>.
nv=BASE&Locale=en_US&SiteID=allume&id=ShoppingCartPage
Then I would paste the list of file paths into a column in Excel.
Excel can control PowerPoint via remote control (called OLE) using either
an
AppleScript or a Visual Basic routine.
Using remote control you can tell Excel to open any particular PowerPoint
presentation in your system, or loop through them. You can tell PowerPoint
to print the active presentation, and do lots of other stuff.
Does this sound like an approach you might want to take? If so, do you
have
any experience with AppleScript or VB?
-Jim Gordon
Mac MVP
Quoting from "Jack" <
[email protected]>, in article
(e-mail address removed), on [DATE:
AFAIK, PPt files aren't embeddable as objects.
The first thing that comes to mind is to create hyperlinks to the other
files by selecting text or an object, then go to Slide Show>Action
Settings
or go to Insert>Hyperlink & specify the target file.
When you want to activate one of the target presentations from within
the
"master" Command+Click the hyperlink & select Hyperlink>Open (or Open in
New
Window), then use the Edit>Edit Slides command.
You might also consider "putting all the eggs in one basket" & using the
Slide Show>Custom Shows... Feature. You might check it out in PPt Help.
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 6/1/07 7:14 PM, in article
(e-mail address removed), "Jack"
On Jun 1, 4:10 pm, "CyberTaz" <typegeneraltaz1ATcomcastdotnet> wrote:
I'm not totally clear on what you're specifically looking to do, but
have
you tried Insert>Slides From File?
--
HTH |:>)
Bob Jones
[MVP] Office:Mac
I am attempting to create one presentation based on the contents of
several others.
I had a lead about this in another post suggesting that I could use
Include/Object/Create from file to pull the contents of an existing
presentation into a second presentation. That was very promising.
Right now though I am receiving an error dialog box when I click "OK"
to include another file. This happens after I have selected the file
and clicked the "Display as icon" check box. It states:
The server application, source file, or item cannot be found. Check
that the path and file name are correct, or try reinstalling the
server application.
I see that there have been posts in this group about this. But these
seem to pertain to trying to include charts w/in the PPT presentation
and were resolved by (re)installing the Chart portion of Office. I
don't see a connect here since the "application" needed is PowerPoint
(I think).
All I could think of was to try renaming the files so that they have
no white space and their names and that of the containing folder are
all 8.3 compliant.
I'm using PPT version x. Has anyone been able to successfully
accomplish this? I'm beginning to think that I've just found a PPT
bug.
That would be fine if I only had to 'assemble' the pieces once, but I
need this to be more dynamic. My PPT presentations are printed to
become the textbooks I use in classes. Think of the individual
presentations as chapters in these 'books'. I occasionally make
revisions to some of the chapter presentations and would like the book
to have links to the chapters instead of copies of the chapters so
that the next time I print the 'book' presentation the revisions in
the 'chapter' presentations are incorporated automatically.
I would like something like A_class.ppt containing:
title slide
link to disclaimer presentation
table of contents slide(s)
link to first chapter presentation
link to second chapter presentation
custom content slide(s) that make up the third chapter
link to fourth chapter presentation
Does that help to clarify?
I don't think that hyperlinking will do it because I need to print
these presentations.
The Custom Shows is way too cumbersome. (I'd have over 500 slides in
several of the classes.) And unless I put absolutely every slide for
every show (around 4000) into one presentation it doesn't solve the
sharing problem.
Can anyone comment on using the Include/Object/Create from file
functionality? There is a post here demoing that in the Windoze
version of PPT.
Has anyone got hands on experience using that on the Mac side?
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/
Jim;
Thanks for these ideas. Having a list of the files in Excel and then
driving from there via VB or AppleScript sound tremendous. Any
resources you can share about this kind of VB coding or AppleScript
scripting?
I have done a lot of coding (C, Javascript, Oracle's PL/SQL) but only
a little with each of these.
Jack