Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening files in other programs
I'm very new to macros so I'll apologize for asking what is probably a
simple question. I want my macro to open a different program. I'm fairly sure this is possible, but can anyone tell me how to do it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening files in other programs
Have a look in vba help for SHELL
-- Don Guillett SalesAid Software "Ldf77" wrote in message oups.com... I'm very new to macros so I'll apologize for asking what is probably a simple question. I want my macro to open a different program. I'm fairly sure this is possible, but can anyone tell me how to do it? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening files in other programs
Ld
Use the "Shell" method. Example.......... Sub Internet_Explorer() Dim taskID As Variant On Error Resume Next taskID = Shell("start iexplore.exe") If Err < 0 Then _ MsgBox "IEXPLORE.EXE is not installed on your machine." End Sub Gord Dibben Excel MVP On 9 Apr 2005 05:01:31 -0700, "Ldf77" wrote: I'm very new to macros so I'll apologize for asking what is probably a simple question. I want my macro to open a different program. I'm fairly sure this is possible, but can anyone tell me how to do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening/converting other spreadsheet programs' files | Excel Worksheet Functions | |||
Opening Different Programs using Excel. | Excel Worksheet Functions | |||
opening different programs with excel macro buttons | Excel Worksheet Functions | |||
Opening multiple programs in VBA | Excel Discussion (Misc queries) | |||
OPENING TWO DIFFERENT EXCEL PROGRAMS | Excel Discussion (Misc queries) |