Not that I know--but couldn't you just add a new workbook and strip out any
numeric characters at the far right to get the name.

But I would think that it would be easier not depending on the name at all.

dim wkbk as workbook
set wkbk = workbooks.add 'new workbook

then use that workbook variable where you want to.

wkbk.worksheets(1).range("a1").value = "hi there!"



sali wrote:

is it possible to know what are default names on particular excel
instalation?
usualy, the name for the new workbook is "book1" [where the base name is
"book"],
but it varies for the other localized languages.
the same applies for sheets, charts ...

is there some application level property that may be read/write to define
new object't default base name?

--

Dave Peterson