Hello everyone
I have a bit a strange situation with a unsaved Excel file.
Explanation:
Macro file 1 (creates new workbook from a template and fills in data from a CSV file. At the end that new workbook gets opened but not yet saved)
Macro file 2 (contains macros to further manipulate the data of the file created by macro file 1)
Regardless if macro file 2 is open or closed at the start of macro file 1, when the new workbook is opened, the macro list is empty.
If the excel file gets saved then, the macros from macro file 2 appear.
Is there a possibility that the macros from macro file 2 appear without saving the data file beforehand, and if yes how would I do that?
Thanks in advance for any insight into this case.
I have a bit a strange situation with a unsaved Excel file.
Explanation:
Macro file 1 (creates new workbook from a template and fills in data from a CSV file. At the end that new workbook gets opened but not yet saved)
Macro file 2 (contains macros to further manipulate the data of the file created by macro file 1)
Regardless if macro file 2 is open or closed at the start of macro file 1, when the new workbook is opened, the macro list is empty.
If the excel file gets saved then, the macros from macro file 2 appear.
Is there a possibility that the macros from macro file 2 appear without saving the data file beforehand, and if yes how would I do that?
Thanks in advance for any insight into this case.