Opening another application from excel - PLEASE - REALLY NEE

willlobb · Apr 3rd, 2002, 04:58 AM

Is there any way you can get excel to open a microsoft word document? ie does anyone know the visual basic code?

[ This Message was edited by: willlobb on 2002-04-03 04:12 ]

[ This Message was edited by: willlobb on 2002-04-03 04:13 ]

willlobb · Apr 3rd, 2002, 05:13 AM

I REALLY NEED HELP WITH THIS ONE!!!

Tom Schreiner · Apr 3rd, 2002, 05:15 AM

Hi
Is Excel just going to open Word?
If so:
AppActivate "Microsoft Word"
Or
Will it open it and communicate via Ole?
If so:
Need more info???
Tom

[ This Message was edited by: TsTom on 2002-04-03 04:17 ]

willlobb · Apr 3rd, 2002, 05:16 AM

it'll just open Word. Thanks
can u help with my other post too?

[ This Message was edited by: willlobb on 2002-04-03 05:11 ]

Tom Schreiner · Apr 3rd, 2002, 05:17 AM

AppActivate "Microsoft Word"

willlobb · Apr 3rd, 2002, 05:22 AM

that didnt work. is it because im using a mac?? is there any other way?
Thanks

Tom Schreiner · Apr 3rd, 2002, 05:26 AM

Hi
I have no clue as to the syntax differences.
Look these up in help...

MacID Function
AppActivate Statement
Shell Function

Tom

Jack in the UK · Apr 3rd, 2002, 04:07 PM

Hi

i dont know for iMac but excel defaults a Excel file called samples which Misrofoft kindley give the code you ask for and explain its use.. this will help iMac might be different but VBA is Made copyright by Microsoft so guess will be all OK an should work never tested i add.. but even so find the doc or scan CD Disk to find..

HTH

Apr 3rd, 2002, 04:07 PM	#8
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi i dont know for iMac but excel defaults a Excel file called samples which Misrofoft kindley give the code you ask for and explain its use.. this will help iMac might be different but VBA is Made copyright by Microsoft so guess will be all OK an should work never tested i add.. but even so find the doc or scan CD Disk to find.. HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 04:58 AM	#1
willlobb Board Regular Join Date: Mar 2002 Posts: 103	Is there any way you can get excel to open a microsoft word document? ie does anyone know the visual basic code? [ This Message was edited by: willlobb on 2002-04-03 04:12 ] [ This Message was edited by: willlobb on 2002-04-03 04:13 ]

Apr 3rd, 2002, 05:13 AM	#2
willlobb Board Regular Join Date: Mar 2002 Posts: 103	I REALLY NEED HELP WITH THIS ONE!!!

Apr 3rd, 2002, 05:15 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Is Excel just going to open Word? If so: AppActivate "Microsoft Word" Or Will it open it and communicate via Ole? If so: Need more info??? Tom [ This Message was edited by: TsTom on 2002-04-03 04:17 ]

Apr 3rd, 2002, 05:16 AM	#4
willlobb Board Regular Join Date: Mar 2002 Posts: 103	it'll just open Word. Thanks can u help with my other post too? [ This Message was edited by: willlobb on 2002-04-03 05:11 ]

Apr 3rd, 2002, 05:17 AM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	AppActivate "Microsoft Word"

Apr 3rd, 2002, 05:22 AM	#6
willlobb Board Regular Join Date: Mar 2002 Posts: 103	that didnt work. is it because im using a mac?? is there any other way? Thanks

Apr 3rd, 2002, 05:26 AM	#7
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi I have no clue as to the syntax differences. Look these up in help... MacID Function AppActivate Statement Shell Function Tom