Fixes problem with save button not working in Excel, The following process is not applicable to COM Add-ins, which may have to be re-installed in the target computer using the installer provided by its publisher. Return new ActiveXObject("Excel.Application") Īlert("Unable to open Excel. Excel VBA add-ins can easily be copied from one computer to another. I added a reference to Microsoft Activex Data Objects 2.8 Library.
How to load excel vba on excel 2018 code#
Here's a simplified version of our fix: function GenerateSpreadsheet()ĮxcelApp.Cells(1,1).value = 'This is an auto-generated spreadsheet, created using Javascript and ActiveX in Internet Explorer' Į("A:IV").EntireColumn.AutoFit Į("1:65536").EntireRow.AutoFit Is it the right code to assign a cell value from a CSV file I do not need to load the whole data into an array, I just need one marching field, and I need to develop this option using VBA and ADO, not standard Excel functions. Essentially we would create the Excel Application object in memory, then reload a specific add-in to get our save button behavior back. Using the other answers here I was able to construct a solution in JavaScript. You would click save and nothing happened. When JavaScript generated a spreadsheet in Excel, suddenly the Save button no longer worked.
How to load excel vba on excel 2018 windows 7#
The add-in gives you the option of saving the file locally or in our online document management system.Īfter we upgraded to Windows 7 and Office 2010, we noticed a problem with our spreadsheet-generating web app.
We also have an Excel add-in that overrides the behavior of the Save button. In my company we have a 3rd party web app that used JavaScript to launch Excel and generate a spreadsheet on the fly. I'm leaving this answer here for anyone else who ran into this problem, but using JavaScript.Ī little background.
0 kommentar(er)
