Why not just create the new workbook within the current instance of excel with
workbooks.add?

(I have no idea where those names are stored and whether you can access it
directly.)

sali wrote:

"Dave Peterson" wrote in message
...
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.

you are right, there are workarrounds, but just wanted "not to reinvent the
wheel"
but, obviously, default "new" names are stored somewhere!

problem i am solving is to "catch" newly created, not yet saved documents
created by some other instance of excel app.
i am using "getobject()" to examine open workbooks.


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

--

Dave Peterson