I have several workbooks each containing 1 sheet and I want to combine them
into 1 workbook. This is easy enough - A function loops through the
workbooks and adds their sheets to a new workbook which it returns. The
problem is that I would like to do this within my VB application, of a PC
that won't neccessarily have Office installed.
Presumably therefore I will need to include part of Office in my
application. Can anyone tell me how to accomplish this in VB or direct me to
a more appropriate Newsgroup?
Thanks for any help.

Rob,
If Excel can't/won't be installed , your options are limited.
If it is only data that you want and that data is organised in a database
type design, ADO may work.
Otherwise, there's the free Open Office that can work with Excel files.

There have been recent posts here on reading the Excel binary format (BIFF).
Although fast, it is not easy to get right.
Writing out to an Excel file is more robust.

NickHK

"Rob" wrote in message
...
I have several workbooks each containing 1 sheet and I want to combine
them
into 1 workbook. This is easy enough - A function loops through the
workbooks and adds their sheets to a new workbook which it returns. The
problem is that I would like to do this within my VB application, of a PC
that won't neccessarily have Office installed.
Presumably therefore I will need to include part of Office in my
application. Can anyone tell me how to accomplish this in VB or direct me
to
a more appropriate Newsgroup?
Thanks for any help.