set Form1=WorkBooks("Something.xls")

HTH
--
AP

"grantj" a écrit dans
le message de news: ...

I know how to name an active workbook with the following command:
Set Form7 = ActiveWorkbook

In this case I named the active workbook "Form7" which permits me to
activate and interact with the workbook.

Is it possible to name more than one active workbook (with different
names) at the same time and be able to activate and interact with them?
Apparently the way I use the command, the most recent workbook is the
active workbook and previous active workbooks that were given names are
no longer valid.


--
grantj
------------------------------------------------------------------------
grantj's Profile:
http://www.excelforum.com/member.php...o&userid=35021
View this thread: http://www.excelforum.com/showthread...hreadid=548972