I am trying to insert a worksheet from file into an open workbook via VBA code.
What should the code look like??

Yes.
Click on a cell, then select Insert Hyperlink.
Then use the browser to select the Word document you want.
--
Gary's Student


"manillla" wrote:

I am trying to insert a worksheet from file into an open workbook via VBA code.
What should the code look like??

The file with the worksheet you want has to be open first, or else you will
have to open it.

Then:

Workbooks("COPYFROM").Worksheets("DESIREDSHEET").C opy _
befo=ActiveSheet


Workbooks("CopyFromFile.xls").copy
"manillla" wrote in message
...
I am trying to insert a worksheet from file into an open workbook via VBA
code.
What should the code look like??