dim myWkbk as workbook
set mywkbk = activeworkbook
'''do lots of stuff
mywkbk.activate

But lots of times you don't even have to activate it to work with it.

mywkbk.worksheets("sheet1").range("B37").value = "Hi there"

would assign a text value to B37 in sheet1 of that workbook.

Mervyn Thomas wrote:

Can someone tell me how to define a variable to hold the name of the current
file so that later I can reactivate the file by referring to the variable
rather hard code its name?

Thanks - It escapes me !

--

Dave Peterson