I have macro in my PERSONAL.xlsb file that are available normally when I open a new Excel sheet. If I open a .csv file from File->Open, the macros are still available. However, when I open a .csv file directly from the desktop or from the folder it is located, the macros are not available. It looks like when loading a .csv direct from the desktop PERSONAL.xls does not load.


Since iam trying to automate this process using an automation tool, i wanted to open the .csv file directly from it's location....

Any help??