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

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

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

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