Insert worksheet
 

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

Insert worksheet
 

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

Insert worksheet
 

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