Can another application be started from Excel w/VBA? 1

[jnameika]

Hi, I don't have access to Schedule Tasks in Window due to our info security gustapo. So I cannot automate running some reports and hope there is a way to initiate external applications from within an Excel spreadsheet. I tried "application.run "'filename.ext'" and it cannot find the file. Is it even possible?

Thanks in advance!

Jim

 

[PHV]

You may consider the Shell function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jnameika]

Thank you! That did the trick. I have been out of "it" for too long!


Dim RetVal
RetVal = Shell("C:\WINDOWS\NOTEPAD.EXE", 1)
' Runs Notepad