[AccessD] New excel workbooks

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.

/gustav

>>> jwcolby at ColbyConsulting.com 21-01-2006 17:44:14 >>>
Are workbooks "named" when they are saved in the Workbooks() collection, and
if so does it use the filespec as the name?  If not, how do you specify
switching to a specific new workbook if there are several workbooks in the
workbook collection?

John W. Colby
www.ColbyConsulting.com