Open an Excel Document in Word

[LW_Greeney]

Hello Again Guys What the VB code to open up an Escel Document externally not
within work from a button which is inputted into a word document?

Cheers Again

Alistaire

 

[Jean-Guy Marcil]

LW_Greeney was telling us:
LW_Greeney nous racontait que :

Hello Again Guys What the VB code to open up an Escel Document
externally not within work from a button which is inputted into a
word document?

???
Please, take a breather and try to re-write your question so that we can
understand it... Personally, I cannot understand what you are asking...
maybe it is too late in the day over here?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[LW_Greeney]

I would like to open an excel document froma command button in word, so I can
edit the sheet and then return to the word document. I dont want to insert
the excel document i was to actually load it up fully away from word

 

[Jean-Guy Marcil]

LW_Greeney was telling us:
LW_Greeney nous racontait que :

I would like to open an excel document froma command button in word,
so I can edit the sheet and then return to the word document. I dont
want to insert the excel document i was to actually load it up fully
away from word

Why not just launch Excel the regular way?

In any case...
Set a reference to the Microsoft Excel Object Library in "References..."
from the "Tools" menu in the VBA Editor.

Then call this code from the command button:

'_______________________________________
Dim xlApp As Excel.Application

Set xlApp = CreateObject("Excel.Application")
xlApp.Workbooks.Open "C:\Book1.xls"
xlApp.Visible = True
'_______________________________________



--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org