Hello once more,
I have yet another question... I dont know if this is something I am doing on my end, Excel bug, or perhaps its a normal feature.. but I have noticed whenever I open an XLT Template file I have created, Excel automatically inserts a "1" into the filename upon opening the file.
This would not ordinarily be a problem, except for the fact that I am running literally dozens of macros which refer to that Template file..with its filename,,MINUS the "1" that Excel seems to have added...hence causing the macros to bomb. (Ie, if the Template file is named "MyTemplate.XLT".. when I open the file from Windows Explorer or the desktop, etc, the filename of the open template suddenly becomes "MyTemplate1.XLT?).
Is there a way to correct this so that the "1" is not added? Or is there a real purpose for this? Anyways, its not a huge deal... If I open the file FROM within Excel.. this does not occur..only when opening the file from a Explorer window, etc)
Thanks again, in advance,
Rob
I have yet another question... I dont know if this is something I am doing on my end, Excel bug, or perhaps its a normal feature.. but I have noticed whenever I open an XLT Template file I have created, Excel automatically inserts a "1" into the filename upon opening the file.
This would not ordinarily be a problem, except for the fact that I am running literally dozens of macros which refer to that Template file..with its filename,,MINUS the "1" that Excel seems to have added...hence causing the macros to bomb. (Ie, if the Template file is named "MyTemplate.XLT".. when I open the file from Windows Explorer or the desktop, etc, the filename of the open template suddenly becomes "MyTemplate1.XLT?).
Is there a way to correct this so that the "1" is not added? Or is there a real purpose for this? Anyways, its not a huge deal... If I open the file FROM within Excel.. this does not occur..only when opening the file from a Explorer window, etc)
Thanks again, in advance,
Rob