tweak_four17
New Member
- Joined
- Aug 2, 2013
- Messages
- 14
Hello,
I'm trying to create a macro in VBA using excel 2003 and/or 2010 to launch an external application. My system has 4 monitors attached to it and I would like to be able to position the application on a specific part of one of the monitors once it is opened.
Currently I am using
Dim Filename As String
Dim retVal As Variant
Filename = "filename.entension"
retVal = Shell("C:\Program Files\Program.exe " & Filename, vbMaximizedFocus)
This opens the correct file with the program but it only ever opens on monitor 1 (and not maximized either I might add)
I've managed to get Internet Explorer to open where I want by using
Set objIE = CreateObject("InternetExplorer.Application")
With objIE
.navigate "www.yahoo.com"
.visible = true
.Top = -1080
.Left = 3840
.Height = 1080
.Width = 1920
End With
Is it possible to do something similar with "Program.exe"? The program in question is a third party business application, not a microsoft application or anything like that..
I'm trying to create a macro in VBA using excel 2003 and/or 2010 to launch an external application. My system has 4 monitors attached to it and I would like to be able to position the application on a specific part of one of the monitors once it is opened.
Currently I am using
Dim Filename As String
Dim retVal As Variant
Filename = "filename.entension"
retVal = Shell("C:\Program Files\Program.exe " & Filename, vbMaximizedFocus)
This opens the correct file with the program but it only ever opens on monitor 1 (and not maximized either I might add)
I've managed to get Internet Explorer to open where I want by using
Set objIE = CreateObject("InternetExplorer.Application")
With objIE
.navigate "www.yahoo.com"
.visible = true
.Top = -1080
.Left = 3840
.Height = 1080
.Width = 1920
End With
Is it possible to do something similar with "Program.exe"? The program in question is a third party business application, not a microsoft application or anything like that..