Bryan Carbonnell
carbonnb at sympatico.ca
Sat Jan 21 11:23:50 CST 2006
On 21 Jan 2006 at 18:10, Gustav Brock wrote: > Hi John > > Workbooks.Add > > A new workbook gets the id equal to the count of workbooks. > > lngWorkbooks = Workbooks.Count > strWorkbookNewName = Workbooks.Item(lngWorkbooks).Name > > That's a default localized name like "Book2" etc. until you save it. You could set a workbook variable to the new workbook when you create it. dim wbkNew as Excel.Workbook wbkNew = Workbooks.Add -- Bryan Carbonnell - carbonnb at sympatico.ca Never test for a bug you don't know how to fix.