Insert worksheet

[manillla]

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

[Gary's Student]

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??

[William Benson]

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").Copy _
before:=ActiveSheet


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