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

"Gary''s Student" wrote:

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

--
Gary''s Student


"PaulW" wrote:

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.



"Gary''s Student" wrote:

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.
--
Gary's Student


"PaulW" wrote:

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?

"Gary''s Student" wrote:

Something like

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


"PaulW" wrote:

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