I want to have text files (.bas, .cls) with the updated version of my codes in a xls file.
I guess I can't do a reference from the xls to the files and run the codes from the text files. The code must be in a module in the xls.
So my idea was to write a Sub Workbook_BeforeSave. So, everytime I save the xls file, it would run the code inside it. And there I would put a macro to export my modules.
I have searched macros to export my modules, but they don't work for me.
They are based on the VBProject property of ActiveWorkbook (or ThisWorkbook). (One example is in http://edndoc.esri.com/arcobjects/9.0/Samples/Application_Framework/ExportVBACode.htm)
I enabled the needed reference to do this ("Microsoft Visual Basic For Applications Extensibility").
But when I run, I get a message that the access to the VB project is not reliable.
Is there anything I can do?
Thanks
Using:
Excel 2003
Windows XP
I guess I can't do a reference from the xls to the files and run the codes from the text files. The code must be in a module in the xls.
So my idea was to write a Sub Workbook_BeforeSave. So, everytime I save the xls file, it would run the code inside it. And there I would put a macro to export my modules.
I have searched macros to export my modules, but they don't work for me.
They are based on the VBProject property of ActiveWorkbook (or ThisWorkbook). (One example is in http://edndoc.esri.com/arcobjects/9.0/Samples/Application_Framework/ExportVBACode.htm)
I enabled the needed reference to do this ("Microsoft Visual Basic For Applications Extensibility").
But when I run, I get a message that the access to the VB project is not reliable.
Is there anything I can do?
Thanks
Using:
Excel 2003
Windows XP