cereal
04-11-2018, 07:01 AM
Hi, so I have a lengthy macro designed to take in data from a data report and create a summary. The macro works well enough for what I want it to do, but I need the macro to be available on every Excel workbook so that I can use the macro in an efficient manner. Currently, I have the macro in a Personal workbook, so the macro is loaded in every time I open excel because the Personal workbook opens at the same time hidden in the background. However, there is a significant problem.
I use a separate application that finds the data and exports the data into an Excel .xls file. My macro is designed to deal with this file, however, the Personal workbook does not open when the exported Excel file is automatically opened after exporting. If I save, close, and reopen, the Personal workbook will be open, but that is inconvenient and a hassle. Is there a way to either open the personal workbook when the new Excel workbook is exported or ensure that my macro will automatically be present in the new file? Thanks!
TL;DR Personal workbook doesn't open when Excel workbook is exported from another application. How do I get my macro to be on the file?
I use a separate application that finds the data and exports the data into an Excel .xls file. My macro is designed to deal with this file, however, the Personal workbook does not open when the exported Excel file is automatically opened after exporting. If I save, close, and reopen, the Personal workbook will be open, but that is inconvenient and a hassle. Is there a way to either open the personal workbook when the new Excel workbook is exported or ensure that my macro will automatically be present in the new file? Thanks!
TL;DR Personal workbook doesn't open when Excel workbook is exported from another application. How do I get my macro to be on the file?