There is a working VBScript code that generates several excel files. We move to a new server where Microsoft Office is not installed. Naturally CreateObject("Excel.Application") does not work.

How to solve the problem without installing Excel? Share proven ways.

  • No way. It all depends on the task. If the task is not complicated, then with xslx you can work as with xml for example. If difficult - look for alternative libraries. - nick_n_a

1 answer 1

As an option, you can save the result in Google Sheets using opensource GSpread.NET . The library allows you to work with Google Sheets using Microsoft Excel API. All code is not necessary to rewrite.

Replace CreateObject ("Excel.Application") with CreateObject ("GSpreadCOM.Application") .

And work with Google Sheets as with a regular Microsoft Excel document.