Macro to open Excel from a Word document

[beanbag]

I have a form in Word where data is linked into it from an Excel worksheet. I would like to write a macro and assign it to a button in Word that will automatically open the Excel worksheet. The form has a large number of calculation in it and seems to perform better when linked with Excel.

I have not figured out how to write the macro to open the Excel application and a specific worksheet.

Any suggestions would be helpful.

 

[dsi]

Just add the MS Excel Object Library to your Project>References and tweak this code as needed.

Note the ReadOnly setting. Set to False if the worksheet can be changed.

Workbooks.Open FileName:="C:\test.xls"
Workbooks.Application.Visible = True
Sheets("Sheet1").Select

Hope this helps.