.xltm

Hi Folks, I've created a multi-macro excel model that I've saved as a *.xltm file i.e., so that the users cannot damage the original file. As hoped, when opened the file becomes filename1 instead of filename.xltm. I can account for this in my vba code by referring to the workbook as...

I have searched but I have not found a solution that has worked. I continually get a "runtime error '1004' method 'saveas' of object '_workbook' failed" in my .xltm file's code while it is attempting to save it as a .xlsm. I have tried different variations and methods but nothing seems to...

The macro I currently have runs from an open workbook and imports sheets from another workbook that is closed. This workbook has "templated" tabs which is why they are being imported. It was proposed in order to have updates to the macro be more flexible (i.e., users would not have to download...