When using the "Open as a CSV file" button on the BOM tab of PDM, the following happens:
- A file named tmp#.tmp (where # is an integer with unknown limit) is created in %AppData%/Local/Temp
- A new instance of Excel opens, and loads tmp#.tmp
I have a macro workbook (PDMMacros.xlsb) that lives in %AppData%/Roaming/Microsoft/XLStart, and should be loaded every time Excel opens. The macros are then used for various clean-up and preparation duties, and the desired workflow is for this clean-up to happen without any user interaction.
My issue is that when the .tmp file is opened automatically from the "Open as a CSV" button, that instance of excel doesn't load my .xlsb file, and therefore my macros aren't available.
Manually opening the .tmp file does loads the .xlsb, as does File > Open > PDMMacros.xlsb.
I'm looking for a way to ensure excel loads my xlsb with the .tmp file, or any other way to automatically run macros on it.
Any advice or suggestions?