I think is going to be a hard one. I know Excel 2003 and newer has a file (it
is called €œExcel11.xlb€� on my computer). In this file Excel saves what
toolbars were visible the last time Excel was shut down. The problem is that
I want to open this file when I am closing a program I have developed. By
opening this file I will restore the toolbars various users have setup on
their Excel. I can already restore built in toolbars, but I want to restore
custom toolbars if any user has set made their own. Excel knows where this
file is located because in accesses it when excel is opened. I know where it
is on my computer, but I can not go around to every ones computer and find
the file and map the location. And I am sure it is not the same name on every
computer. So, if Excel knows where it is, how do I make my program call this
file right before the user closes their program.