what are you trying to do? if you don't want to save  it.. why do you need
to name it?

You are possibly getting misled by the "with" statement. Your code  is
equivalent to

> Set newWB = Workbooks.Add
> WB.Title = "Yield Curves"
> WB.Subject = "Yield Curves"
> Call WB.SaveAs(Filename:="c:\foo.xls")

which is more specific (and two lines shorter),

The important thing to note is that there are actually four separate
statements here, not one multi-line call with several parameters.

If you don't want to save  the file, just remove the SaveAs call.

You do say "create a workbook  and name it". Workbooks are files. They
don't have separate names  - they use the files' names. So, it won't have a
name other than "Book1" until it's saved. (This is similar to other
programs that have a File/New facility - like Word, NotePad, etc.)

Looks like the "New" threw you. It is not a keyword, but part of the name.



The code  should be

newWB.Title = "Yield Curves"

newWB.Subject = "Yield Curve"

Call newWB.SaveAS(Filename:="c:\foo.xls")

Very true, thanks. I've been writing mostly Java for the last several
months and "new" is always a keyword there, so I didn't notice it here.