Hi,

I am trying, if at all possible to do the following.
I want to create a button on an excell sheet that will open and ru
another windows based application.
I then want it to automatically perform certain tasks within tha
program, ie open a file, print or save.
Is this at all possible if so how...
Any help or advise would be most welcome

cheer

--
leePosted from - http://www.officehelp.i

Hi Lee,

See the Shell function in VBA help.


---
Regards,
Norman



"lee" wrote in message
...

Hi,

I am trying, if at all possible to do the following.
I want to create a button on an excell sheet that will open and run
another windows based application.
I then want it to automatically perform certain tasks within that
program, ie open a file, print or save.
Is this at all possible if so how...
Any help or advise would be most welcome

cheers


--
leePosted from - http://www.officehelp.in

I have looked for this in the help file but it isnt listed.
I have this feeling that shell isnt available to me
any further ideas?

ps I am running excel 2000

cheer

--
leePosted from - http://www.officehelp.i

Here is an example of using SHELL to run an external application:

Sub Macro1()
x = Shell("cmd.exe /c C:\Userguide.pdf", 1)
End Sub


This will run Adobe Acrobat. To control the application try SendKeys
--
Gary's Student


"lee" wrote:


I have looked for this in the help file but it isnt listed.
I have this feeling that shell isnt available to me
any further ideas?

ps I am running excel 2000

cheers


--
leePosted from - http://www.officehelp.in