[AccessD] New excel workbooks

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.