seting a workbook to a varible name
 

i forgot how do i set a workbook to a varible name
without using a for each, im sure im just forgeting
something small but cant rember...

pls help me

seting a workbook to a varible name
 

Dim WBVar As WorkBook

Set WBVar = Workbooks("Book1.xls")

Is that what you mean? - Piku

--
Message posted from http://www.ExcelForum.com

seting a workbook to a varible name
 

lol

knew i was missing some thing simple
had the var name and the activeworkbook switched

lol

-----Original Message-----
Dim MyBook as WorkBook
Set MyBook=ActiveWorkBook
OR
Set MyBook = WorkBooks("TheWrkBkName")
.