Shell for non .exe Files

[JValenti]

Hello All,


So I currently am trying to open from VBA, an output file of a macro recordercalled tinytask. I am able to sue theshell function to open the macro recorder itself using the below:
Sub TinyTaskCallExample()

DimstrProgramName As String
Dim strArgumentAs String

'strProgramName= "C:\Users\vajo5001\Desktop\tinytask.exe"
'Call Shell(strProgramName,vbNormalFocus)

End Sub

However, when you save a recording file from the programit saves the file as a .rec file type. Sofor example my file could be called "C:\Users\vajo5001\Desktop\OpenWord.rec". When looking at the file properties it showsOpens With: TinyTask. I just doubleclick on the file on my desktop it loads with no issues and runs the recorded macro.

So how do I open a non-standard filetype such asthis? Is it still with the Shell programand I am just formatting incorrectly?
Replacing with 'strProgramName = " C:\Users\vajo5001\Desktop\OpenWord.rec" does not work.
Thanks Josh

 

[Norie]

Josh

Does this work?

Sub TinyTaskCallExample()

Dim strProgramName As String
Dim strArgument As String

    strProgramName= "C:\Users\vajo5001\Desktop\tinytask.exe"


    strArgument = "OpenWord.rec"

    Call Shell(strProgramName & " " & strArgument ,vbNormalFocus)

End Sub

 

[Kenneth Hobson]

Shell "cmd /c " & "C:\Users\vajo5001\Desktop\OpenWord.rec", vbNormalFocus

 

[JValenti]

Hello Norie,

Yes that seems to have worked, and I was also able to get the following to work:

Shell ("C:\Users\vajo5001\Desktop\tinytask.exe C:\Users\vajo5001\Desktop\OpenWord.rec"

I think they are basically the same thing