or
strWkBkName = Activeworkbook.Name
or
strWkBkName = ThiwWorkbook.Name
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"pikus " wrote in message
...
Well if you want the variable to hold the NAME of the workbook:
Dim strWkBkNam As String
strWkBkNam = "Workbook.xls"
BUT, if you want the variable to be an object reference to the workbook
itself:
Dim WkBk1 As Workbook
Set WkBk1 = Workbooks("Workbook.xls")
Note the use of the "Set" keyword. This must always be used with
object variables. - Pikus
---
Message posted from http://www.ExcelForum.com/