Sub DisplayWordAutomation()
Set wordapp = CreateObject("Word.Application")
'WordApp.Application.Visible = True
With wordapp
.Visible = True
.Activate
.Run (" type macro name here ")
.Quit SaveChanges:=wdDoNotSaveChanges
End With
End Sub
Here is a macro I use to open word from excel and then run a word macro. I would just change the word stuff to powerpoint and create a macro in powerpoint to open the file you want and type that macro name in the macro above (no spaces when you type the name). Let me know if it works.
Hi Qroozn:
I just wanted to jump in on the issue of *.ppt vs *.pps
A file that has a pps (powerPoint show extension) will automatically begin to play -- without having to first open the file and then SlideShow|ViewShow
I understand that yogi.. thats why i named the file as .pps
but surely (hopefully) there must be a different way of opening the file then to open ppt application, and call a macro from ppt which then runs the pps file.
I have an excel program. and i also have a powerpointpresentation about the program.
I want to click on a button in excel and have it run the powerpointshow.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.