Frank,

Have you tried

Set xlBook = xlApp.Workbooks.Add(Template:="Workbook")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"FrankAlva" wrote in message
...

Hi,

I would like to create a new excel file from scratch using VBA.
Here's what I got so far

Dim xlApp As Excel.Application, xlBook As Excel.Workbook, xlSheet As _
Excel.Worksheet

Set xlApp = CreateObject("excel.application")
Set xlBook = xlApp.Workbooks.Open("c:\test.xls", 0, False, 2)
Set xlSheet = xlBook.Worksheets(1)

Now that is to create a new excel file from and existing one
"test.xls". How would I do it to create one without having an existing
one.

Something like Set xlBook = xlApp.Workbooks.New ??

thanks


--
FrankAlva
------------------------------------------------------------------------
FrankAlva's Profile:
http://www.excelforum.com/member.php...o&userid=16208
View this thread: http://www.excelforum.com/showthread...hreadid=277200