workbook as variable

P

pete

for a newly created workbook, how can I store a reference to the
workbook in a variable ,

thanks

pete
 
C

Chip Pearson

Pete,

Try something like

Dim WB As Workbook
Set WB = ActiveWorkbook
' or
Set WB = Workbooks.Add()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
R

Rob van Gelder

Pete,

Sub test()
Dim wkb As Workbook

Set wkb = Workbooks.Add
MsgBox wkb.FullName
End Sub

Rob
 
Top