Open an external application

[Guest]

Within our company we use WRQ Reflections, as part of my job i programme vba
in both excel and Reflections.

I have managed to get Refections to open office applications when run, but i
can figure out the code to open a Reflections session from within Excel.

The extention for the sessions are .r1w

if anyone knows of any code i would be grateful.

Many thanks

 

[Guest]

Something like

Sub Macro1()
x = Shell("cmd.exe /c C:\Userguide.r1w", 1)
End Sub

 

[Guest]

Hi Gary,

thanks for the quick responce, all this is doing is opening the MS-DoS
window launching the cmd.exe file within the System32 folder?

Am i missing something?

 

[Guest]

You will need to replace
C:\Userguide.r1w
with your path and file name

This should work if the file associations are correct; that is, if you can
manually open the .r1w file by double-clikcing its icon.

 

[Guest]

I have it working without sub directories ie\ C:\Userguide.r1w but as soon as
i attempt to add folders it wont open ie\ C:\Folder1\Folder2\Userguide.r1w

Can you help

 

[Guest]

Hi Gary,

I've been testing and the code works as long as there are no breaks in the
folder name. Is there any fix to this.

 

[Guest]

Look at:

Sub Macro1()
ChDir ("c:\Documents and Settings\littlegary\Desktop")
x = Shell("cmd.exe /c Hello"" ""there.doc", 1)
End Sub

First, the blanks can be embedded in ChDir
Second, notice the quad-quoting for the file name in the Shell statement

 

[Guest]

Genius, thats for your help on this gary, much appriciated!!!!!!!

 

[Guest]

You are very welcome !
--
Gary's Student

Genius, thats for your help on this gary, much appriciated!!!!!!!