[indent]
Excel Automation is not allowed on the server running the application.
[/indent]
You mean, you cannot run macros?
How many Excel files are to be combined? If they are a few but containing a zillion worksheets each, try the following VBA-free solution:
– Open all the files to be combined.
– Create a new workbook.
– Select any of the files you opened, and click on the first worksheet tab counting from left to right. The worksheet will become active.
– From the set of arrows to the left of the worksheets tab, press the one right of all (this will scroll all the worksheet tabs to the last, counting from left to right).
– Now hold Ctrl + Shift and click on the last worksheet tab. This way you’ve selected all the worksheets.
– Right click on any worksheet tab. A context menu displays. Select “Move or Copy”, remember to check the “Create a copy” box, choose the workbook you’d created to this effect, select where the worksheets should be inserted. Done.
– Repeat with every workbook.
Hope it works…
