I am having a problem with xlt files when using my code to open them let me explain. Normally when you open an xlt file
excels adds a number to the name so your template is not over written correct?
I have two macros set up the first
without going into to much detail, opens all the xlt files in a folder amends them and resaves them as a xlt with the code
Dim sPath As String
sPath = "J:edecmastersEDECMasterMASTERTESTNew Folder"
On Error Resume Next
ActiveWorkbook.SaveAs sPath & ActiveSheet.Range("B4").Value & ".xlt"
ActiveWorkbook.SaveAs sameName, xlTemplate
The other macro is combined with a userform and allows a
user to pick from a list the xlt files from the folder mentioned above.
Now this is the problem, when I amend a
xlt file with the macro and then open it using my userform it opens as a xlt file but with no additional number but if I open
it directly from the folder it has a number added to the name for example 'E056-114A' becomes 'E056-114A3' the later is what
I would like to happen as I would like to preserve the saved xlt file
Can anyone tell me what is happening because it’s driving me mad?
If my file lookup code is needed I could post also.