Re: Insert worksheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

Then:

Workbooks("COPYFROM").Worksheets("DESIREDSHEET").Copy _
before:=Active***


Workbooks("CopyFromFile.xls").copy
"manillla" <manillla@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F7F52EC-0654-49B5-A3EC-BC4B122133D0@xxxxxxxxxxxxxxxx
> I am trying to insert a work*** from file into an open workbook via VBA
code.
> What should the code look like??


.

Quantcast