-
Opening Excel from Powerpoint
Not sure if this is an Excel thread or a PowerPoint thread, so I confess I'm posting in both.
My problem is that I'm authoring a PowerPoint presentation which is going to switch from Excel to the slideshow and vice versa.I can quickly open Excel initially, simply by assigning an action to a button in the presentation. I can then switch back to the sideshow using the code...
[vba]AppActivate "Powerpoint Slide Show"[/vba]
I could then assign the same action button next time I open Excel,then I get the command pointing out that the file is already open. I can of course simply say that I don't want to reopen it, and proceed from there, but it's a little bit clumsy. Is there a command in PowerPoint back in work like AppActivate command in Excel? The VBA Help says that this command does exist, but the code
[vba]AppActivate "[Microsoft] Excel"[/vba] doesn't seem to launch Excel from the slide show.
What am I doing wrong?
Peter
-
-
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules