-
Mar 10th, 2017, 03:05 PM
#1
Thread Starter
Member
Vb6- Move focus to PowerPoint
The VB6 exe program is launched from an Excel add-in and is supposed to move the focus to an active and open PowerPoint presentation that should become the visible window.
Code:
With PPApp.ActiveWindow
.ViewType = View
End With
PPApp.Activate
While in IDE mode the focus moves properly and PowerPoint is the visible window. But in the compiled form (the exe file) the PowerPoint icon in the taskbar blinks but PowerPoint does not appear on top of Excel
It seem that I have to find the handle of PowerPoint but don't know how to do it
Using Office 2016
-
Mar 10th, 2017, 04:38 PM
#2
Re: Vb6- Move focus to PowerPoint
don't know all your code, but are you using:
anywhere?
-
Mar 10th, 2017, 09:06 PM
#3
Member
Re: Vb6- Move focus to PowerPoint
How about posting all of the code that automates PPT.
Will this work with your current code approach?
https://support.microsoft.com/en-au/...omation-server
If you know the caption (text at top of PPT window) you might be able to use this approach:
http://visualbasic.happycodings.com/...vba/code5.html
-
Mar 11th, 2017, 04:43 AM
#4
Re: Vb6- Move focus to PowerPoint
Have no experience with Automating PowerPoint but xlApp.Caption works for me in Excel so;
Try AppActivate PPApp.Caption
-
Mar 11th, 2017, 04:47 AM
#5
Thread Starter
Member
Re: Vb6- Move focus to PowerPoint
Tags for this Thread
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
|
Click Here to Expand Forum to Full Width
|