| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open an external application
You are very welcome !
-- Gary's Student "PaulW" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External data query leaves datasource workbook open | Excel Discussion (Misc queries) | |||
| How do I open a new window for each excel application? | New Users to Excel | |||
| Can Excel open a new application for every file opened? | Excel Discussion (Misc queries) | |||
| Linking from external application Crystal | Excel Discussion (Misc queries) | |||
| When I open excel document it always ask if I want to open it in . | Excel Discussion (Misc queries) | |||
Threaded Mode
