ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shell to different app then open file within (https://www.excelbanter.com/excel-programming/318075-shell-different-app-then-open-file-within.html)

Justin[_12_]

Shell to different app then open file within
 
Trying to open Reflections for HP and then a file within. I can open easily
office documents but when trying HP cannot open without errors. Here is my
first try:

Dim retval
retval = Shell("C:\Program Files\Reflection\r1win.exe " & _
"""C:\Program Files\Reflection\User\getups.r1w""",
vbMaximizedFocus)

Second attempt:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"c:\program files\reflection\user\getups.r1w"
Range("A1").Select
Selection.Hyperlinks(1).Follow NewWindow:=True, AddHistory:=True
Application.WindowState = xlNormal

Any help greatly appreciated.




All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com