open Excel from Word 2003

[muyBN]

I've seen in this forum how to copy an Excel worksheet into Word but I only
need to open an Excel file and not do anything else to it from the macro.
What do I do to actually open the file with the code below?

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook

Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open("path\file.xls")

 

[Doug Robbins - Word MVP]

Add

xlApp.Visible = True



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[muyBN]

Thanks, Doug. Perfect solution.
--
Bryan

Add

xlApp.Visible = True



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP