Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to start Excel from Word-VBA-Script

Status
Not open for further replies.

webstony

Technical User
Jan 29, 2001
19
DE
Hello everybody,

is it possible to start Excel while running a Word VBA Script? I mean, is it possible to start Excel with an explicit Word-VBA-Script-Order?
And further: Is it possible to overtake a value from an Excel Cell automatically in Word? #-)

Thanks in Advance!

Greetings from Germany,
stony
 
For people who has the same problem:

Sub WrdXl()

Dim ExcApp As Object
Set ExcApp = CreateObject("Excel.Application")
ExcApp.Visible = True
ExcApp.Workbooks.Open "C:\sheet1.xls"
Set ExcApp = Nothing

End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top