I'm having a problem with switching windows in a macro, the file causing the problem is a template file. Assume the template is called template.xlt, have tried the code
windows("Template.xlt").activate
this gives me the error message "Subscript out of range"
I notice that once my template has been updated, Excel renames it as "Template1", and if I run the macro again "Template2". I have tried various ways of activating these files without any joy.
Is there anyway of activating my file?
Thanks
Matt
windows("Template.xlt").activate
this gives me the error message "Subscript out of range"
I notice that once my template has been updated, Excel renames it as "Template1", and if I run the macro again "Template2". I have tried various ways of activating these files without any joy.
Is there anyway of activating my file?
Thanks
Matt