Business wrote a complex Excel VBA macro that scans several complex and irregular (multiple logical tables per tab) spreadsheets and creates a summary XLS. Management wants IT to “produce it” and run it on the server.
I saw an example of using a Jet disk to read regular tables (1 per tab) in a spreadsheet, but spreadsheets are irregular, and this macro does more than read, it sets cell formulas, etc. Therefore, I think we need a full VBA.
How do you do this if you cannot install Excel on a production server?
Chadd source
share