F
FrankAlva
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 on
"test.xls". How would I do it to create one without having an existin
one.
Something like Set xlBook = xlApp.Workbooks.New ??
thank
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 on
"test.xls". How would I do it to create one without having an existin
one.
Something like Set xlBook = xlApp.Workbooks.New ??
thank