running of external application

[Debby Bunce]

hi all,


can somebody point me in the right direction of starting an en external
application ie microsoft outlook with an excel 2003 spreadsheet please

cheers


steve

 

[Bob Phillips]

To start Outlook, all you need is

Dim oOL As Object

Set oOL = CreateObject("Outlook.Application")
oOL.Visible = True

What do you want to do with it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Debby Bunce]

possibly run an application when my spreadsheet has been updated/ or
notified using a macro

rgds


steve

 

[Bob Phillips]

You mean you don't want Outlook now?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Debby Bunce]

Bob

yes i do want outlook to run but i want it run after i have updated and
saved my spreadsheet
but i want it to do this via a macro

so when i write the macro it will save the xls file and run outlook

hope that explains a bit better


rgds


steve

 

[Bob Phillips]

Dim oOL As Object

Activeworkbook.Save
Set oOL = CreateObject("Outlook.Application")
oOL.Visible = True


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Debby Bunce]

bob

thanks



steve

Dim oOL As Object

Activeworkbook.Save
Set oOL = CreateObject("Outlook.Application")
oOL.Visible = True


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Martin Rice]

Steve

Look in the VBA help for the SHELL function.


Martin

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Visit Eighty-Twenty Spreadsheet Automation for professional customised
spreadsheet development

http://homepage.ntlworld.com/martin.rice1/