| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I bring up a seperate program with macros? Hit a button and b.
I would like to add a button that when selected, opens up a totally
seperate program on my computer. Is this possible? I have a spreadsheet that relies on data from different sources. When filling out the spreadsheet, I would like to be able to simply click and the information source software is initiated. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I bring up a seperate program with macros? Hit a button and b.
Hi
in the VBA help look for Shell -- Regards Frank Kabel Frankfurt, Germany "Jack Webb" schrieb im Newsbeitrag ... I would like to add a button that when selected, opens up a totally seperate program on my computer. Is this possible? I have a spreadsheet that relies on data from different sources. When filling out the spreadsheet, I would like to be able to simply click and the information source software is initiated. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I bring up a seperate program with macros? Hit a button and b.
Look up shell in VBA.
"Jack Webb" wrote: I would like to add a button that when selected, opens up a totally seperate program on my computer. Is this possible? I have a spreadsheet that relies on data from different sources. When filling out the spreadsheet, I would like to be able to simply click and the information source software is initiated. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I bring up a seperate program with macros? Hit a button and b.
Jack
"Just the facts, ma'am" Use the "shell" command. Sub CharMap() Dim taskID As Variant On Error Resume Next taskID = Shell("start charmap.exe") If Err < 0 Then _ MsgBox "CHARMAP.EXE is not installed on your machine." End Sub Gord Dibben Excel MVP On Tue, 21 Dec 2004 13:13:03 -0800, Jack Webb wrote: I would like to add a button that when selected, opens up a totally seperate program on my computer. Is this possible? I have a spreadsheet that relies on data from different sources. When filling out the spreadsheet, I would like to be able to simply click and the information source software is initiated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill options button for Dates disappears- bring it back? | Excel Discussion (Misc queries) | |||
| Button for bring up chart | Excel Worksheet Functions | |||
| Button not bring up Macro I created | Excel Discussion (Misc queries) | |||
| Macro to bring up Other Program | Excel Programming | |||
| bring up dialog box from command button? | Excel Programming | |||
Linear Mode
