ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro to open specific document (https://www.excelbanter.com/excel-discussion-misc-queries/122483-macro-open-specific-document.html)

Thew21

Macro to open specific document
 
Hi, Im trying to use a macro in excel to open up a powerpoint document.
However when i try it just says document not found. I am using the Shell
command and it works if I just try to open Access and work. But if i try to
open any other specific document it just says not found.

Thanks

Richard

Gary''s Student

Macro to open specific document
 
Try something like:

Sub Macro4()
x = Shell("cmd.exe /c C:\sample.ppt", 1)
End Sub


--
Gary's Student


"Thew21" wrote:

Hi, Im trying to use a macro in excel to open up a powerpoint document.
However when i try it just says document not found. I am using the Shell
command and it works if I just try to open Access and work. But if i try to
open any other specific document it just says not found.

Thanks

Richard



All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com