I have written some code to generate a ppt. from some excel data. the code is run by pressing a command button in excel. ppt then fires up in the background, generates the ppt. and then displays a splash screen with a button to 'view' the ppt.
When this button is pressed I want the macro to switch windows from excel to powerpoint. (alt + tab in effect).
All the code runs fine however, the last line where powerpoint should be brought to the front just seems to do nothing. If however I then open the visual basic editor, click in the code window and then close it all again, it runs completely differently.
I have attached a file which displays the problem on my machine & others on the network i''ve tested it with.
Someone on here tried it yesterday for me and said it worked fine for him, however he wasnt able to use a share screen app to see the problem in action on my pc.
Hope someone is able to help,
Freddie
Test.xlsm
Bookmarks