It gets asked many times about external macros, or, essentially controlling, say in excel, a spreadsheet from outside of that spreadsheet. The only way that I know of is to make a separate .xls file that would need to be opened each time you wanted a macro to run - thereby showing the "Macros are in this file" warning when the .xls file opens.
Is there any other ways to include even a subroutine outside of a spreadsheet that could be run?
For example, I have developed a spreadsheet used by many people in my company. When I want to release updates, or "fixes" to the program code, I need to send them a whole new .xls file. It would be slick If I only need to send an external file and the spreadsheet would either use that file or would update itself based on that file...
Is this a popular wish or am I just talkin' crazy!?
)
Is there any other ways to include even a subroutine outside of a spreadsheet that could be run?
For example, I have developed a spreadsheet used by many people in my company. When I want to release updates, or "fixes" to the program code, I need to send them a whole new .xls file. It would be slick If I only need to send an external file and the spreadsheet would either use that file or would update itself based on that file...
Is this a popular wish or am I just talkin' crazy!?
)