thefrasers
05-04-2008, 07:17 AM
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...
AppActivate "Powerpoint Slide Show"
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
AppActivate "[Microsoft] Excel" doesn't seem to launch Excel from the slide show.
What am I doing wrong?
Peter
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...
AppActivate "Powerpoint Slide Show"
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
AppActivate "[Microsoft] Excel" doesn't seem to launch Excel from the slide show.
What am I doing wrong?
Peter