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.