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" <manillla@discussions.microsoft.com> wrote in message
news:7F7F52EC-0654-49B5-A3EC-BC4B122133D0@microsoft.com...
> I am trying to insert a worksheet from file into an open workbook via VBA
code.
> What should the code look like??