|re: Does anyone know the path to the macro data file ?|
I'm a bit confused. I'm not familiar with the term "macro data file". Maybe I'm missing something in your question.
Excel macros are typically stored ether in any given workbook, in which case they would be available only when that workbook is open, and/or in a file named personal.xls, which is created by the user and typically stored in the XLSTART folder.
If Excel finds a personal.xls file in the XLSTART folder, it will open it whenever Excel opens so that the macros stored in it are available in all workbooks. Typically the user would Hide the personal.xls file before saving it so that it opens Hidden and doesn't get in the way.
Do you have an XLSTART folder for every user on every TS?
What will happen when the user adds/edits a macro in his/her personal.xls file? Wouldn't it only get saved on the TS currently in use?
Having multiple copies of personal.xls, which are not in sync with each other, is going to be awfully confusing to the users. Sometimes macros will be there, sometimes not.
Am I way off base here?