VBA not saving template

[mickyh]

Hello and merry Christmas.

I have a template which with a lot of help on from members which saves a spreadsheet with the next sequential number (by adding a number to the relevant square in the template file). This worked great until I made some changes to it! Everything still works as I need it to except it doesn't seem to update the template number therefore every time I run the template it gives the next file the same number. I cannot figure out why this so any help would be gratfully accepted!

Regards

Mick

Please Login or Register  to view this content.

[xladept]

Maybe:

Please Login or Register  to view this content.

[mickyh]

Thanks for the reply: The problem I'm having is with the template. it should (and used to) increase the number by 1 in J2 each time the macro was run and save the new number. (so that when the macro was used next it gave the next sequential No) everything works as I need it to apart from the no in J2 in the template being incremented.

Please Login or Register  to view this content.

[xladept]

Hi micky,

Is your Template really a template extension .xltx??

[mickyh]

Hi xladept
My template is a macro enabled template .xltm. again it all appears to work except that it wont save the updated no on the template. it might be that activeworkbook reference that's wrong? unfortunately I don't understand enough about vba to solve it!

Thanks for getting back to me.

[mickyh]

I Found the error it needed to have ,editable = true after the path to open the template!

Please Login or Register  to view this content.

[xladept]

Good to know! Glad you got it