I am trying to insert a worksheet from file into an open workbook via VBA code.
What should the code look like??
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").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??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks