Syntax to define a variable for current file

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

Mervyn Thomas

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 !
 
Mervyn,

Try something like

Dim FName As String
FName = ActiveWorkbook.Name
' more code here
Workbooks(FName).Activate


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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.
 
Back
Top