P pete Jan 25, 2004 #1 for a newly created workbook, how can I store a reference to the workbook in a variable , thanks pete
for a newly created workbook, how can I store a reference to the workbook in a variable , thanks pete
C Chip Pearson Jan 25, 2004 #2 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
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 Jan 25, 2004 #3 Pete, Sub test() Dim wkb As Workbook Set wkb = Workbooks.Add MsgBox wkb.FullName End Sub Rob
