Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook as variable
for a newly created workbook, how can I store a reference to the
workbook in a variable , thanks pete |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook as variable
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" wrote in message ... for a newly created workbook, how can I store a reference to the workbook in a variable , thanks pete |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook as variable
Pete,
Sub test() Dim wkb As Workbook Set wkb = Workbooks.Add MsgBox wkb.FullName End Sub Rob "pete" wrote in message ... for a newly created workbook, how can I store a reference to the workbook in a variable , thanks pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pass variable from one workbook to another | Excel Discussion (Misc queries) | |||
Vlookup using a variable for the workbook name | Excel Discussion (Misc queries) | |||
Can not set WorkBook variable | Excel Discussion (Misc queries) | |||
How do I link to a workbook whose name is variable? | Excel Discussion (Misc queries) | |||
Activating workbook with variable Name | Excel Programming |