smason48
New Member
- Joined
- Jan 12, 2010
- Messages
- 15
Right, I am a collaboration of advanced vba minds, I have a nice hard one for the holidays!
I basically have developed some VBA which takes snapshots of data in excel and copys/pastes it into PowerPoint, along with titles and text boxes etc... and it works fantastic, however rather unsightly as there are many slides and there's a lot of flashing and visual activity going on.
I want to hide all this from the user in the way of a form on screen (or another method) just to make it look more professional. For the excel parts I use Application.Screen Updating = False, however this does not work in PowerPoint and the alternative to open power point in the backgrounds means the script doesn't run correctly.
I have tried to use a form and make modal = false but as I am going cross application it ends up disappearing. I fear I am way out of my depth but the only thing I can thing of is somehow loading a windows reference library into excel and making a modal:false windows dialog box appear in-front.
Any thoughts on how I could do this or an alternate route? Or anybody been in this predicament?
Thanks in advance guys.
I basically have developed some VBA which takes snapshots of data in excel and copys/pastes it into PowerPoint, along with titles and text boxes etc... and it works fantastic, however rather unsightly as there are many slides and there's a lot of flashing and visual activity going on.
I want to hide all this from the user in the way of a form on screen (or another method) just to make it look more professional. For the excel parts I use Application.Screen Updating = False, however this does not work in PowerPoint and the alternative to open power point in the backgrounds means the script doesn't run correctly.
I have tried to use a form and make modal = false but as I am going cross application it ends up disappearing. I fear I am way out of my depth but the only thing I can thing of is somehow loading a windows reference library into excel and making a modal:false windows dialog box appear in-front.
Any thoughts on how I could do this or an alternate route? Or anybody been in this predicament?
Thanks in advance guys.