Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Createing an excel file
- Thread starter jabmod
- Start date
you can use the excel automation server, ideally late bound so that you can maintain compatibility with other versions of excel on the client box:
dim oxlApp as Object
dim oxlWB as object
set oxl = createobject("Excel.Application")
set oxlWB = oxl.workbooks.add
with oxlWB
'do all your stuff to populate the workbook / sheets
end with
oxl.saveas "your target filename"
'release memory
set oxlWB = nothing
oxlApp.quit
set oxlApp = nothing
Hope this is of use.
VBrit
dim oxlApp as Object
dim oxlWB as object
set oxl = createobject("Excel.Application")
set oxlWB = oxl.workbooks.add
with oxlWB
'do all your stuff to populate the workbook / sheets
end with
oxl.saveas "your target filename"
'release memory
set oxlWB = nothing
oxlApp.quit
set oxlApp = nothing
Hope this is of use.
VBrit
bombdropVB
Programmer
Try the following Excell creation In VB this will creat a workbook and sheets without Excel on the machine
Hope this helps
Hope this helps
- Status
