running of external application

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

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" <debbybunce@ntlworld.com> wrote in message
news:CV2_f.302$_S1.102@newsfe5-gui.ntli.net...
> 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
>
>
>

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

rgds


steve



"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:eAJP496WGHA.3672@TK2MSFTNGP02.phx.gbl...
> 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" <debbybunce@ntlworld.com> wrote in message
> news:CV2_f.302$_S1.102@newsfe5-gui.ntli.net...
>> 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
>>
>>
>>
>
>

You mean you don't want Outlook now?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Debby Bunce" <debbybunce@ntlworld.com> wrote in message
news:Qv5_f.188$gq3.128@newsfe7-gui.ntli.net...
> possibly run an application when my spreadsheet has been updated/ or
> notified using a macro
>
> rgds
>
>
> steve
>
>
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:eAJP496WGHA.3672@TK2MSFTNGP02.phx.gbl...
> > 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" <debbybunce@ntlworld.com> wrote in message
> > news:CV2_f.302$_S1.102@newsfe5-gui.ntli.net...
> >> 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

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















Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23tAUdF9WGHA.3672@TK2MSFTNGP02.phx.gbl...
> You mean you don't want Outlook now?
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Debby Bunce" <debbybunce@ntlworld.com> wrote in message
> news:Qv5_f.188$gq3.128@newsfe7-gui.ntli.net...
>> possibly run an application when my spreadsheet has been updated/ or
>> notified using a macro
>>
>> rgds
>>
>>
>> steve
>>
>>
>>
>> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
>> news:eAJP496WGHA.3672@TK2MSFTNGP02.phx.gbl...
>> > 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" <debbybunce@ntlworld.com> wrote in message
>> > news:CV2_f.302$_S1.102@newsfe5-gui.ntli.net...
>> >> 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
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>
>

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" <debbybunce@ntlworld.com> wrote in message
news:hXa_f.4299$LH2.3368@newsfe2-win.ntli.net...
> 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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:%23tAUdF9WGHA.3672@TK2MSFTNGP02.phx.gbl...
> > You mean you don't want Outlook now?
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Debby Bunce" <debbybunce@ntlworld.com> wrote in message
> > news:Qv5_f.188$gq3.128@newsfe7-gui.ntli.net...
> >> possibly run an application when my spreadsheet has been updated/ or
> >> notified using a macro
> >>
> >> rgds
> >>
> >>
> >> steve
> >>
> >>
> >>
> >> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> >> news:eAJP496WGHA.3672@TK2MSFTNGP02.phx.gbl...
> >> > 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" <debbybunce@ntlworld.com> wrote in message
> >> > news:CV2_f.302$_S1.102@newsfe5-gui.ntli.net...
> >> >> 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

thanks



steve



"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23iUSIs$WGHA.5012@TK2MSFTNGP05.phx.gbl...
>
> 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" <debbybunce@ntlworld.com> wrote in message
> news:hXa_f.4299$LH2.3368@newsfe2-win.ntli.net...
>> 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
>> news:%23tAUdF9WGHA.3672@TK2MSFTNGP02.phx.gbl...
>> > You mean you don't want Outlook now?
>> >
>> > --
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > (remove nothere from email address if mailing direct)
>> >
>> > "Debby Bunce" <debbybunce@ntlworld.com> wrote in message
>> > news:Qv5_f.188$gq3.128@newsfe7-gui.ntli.net...
>> >> possibly run an application when my spreadsheet has been updated/ or
>> >> notified using a macro
>> >>
>> >> rgds
>> >>
>> >>
>> >> steve
>> >>
>> >>
>> >>
>> >> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
>> >> news:eAJP496WGHA.3672@TK2MSFTNGP02.phx.gbl...
>> >> > 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" <debbybunce@ntlworld.com> wrote in message
>> >> > news:CV2_f.302$_S1.102@newsfe5-gui.ntli.net...
>> >> >> 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
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>

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/

"Debby Bunce" <debbybunce@ntlworld.com> wrote in message
news:CV2_f.302$_S1.102@newsfe5-gui.ntli.net...
> 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
>
>
>