Using VBA to automate generation of multiple worddocs populated with data from excel sheet
I am using the following start to my VBA project, but when I run it I get a 1004 error and it highlights the below. The error seems to be the path, but I know not what the issue is.
Is there a way to emulate relative referencing in Excel?
So I’m trying to make a template to help streamline some QA work going forward and I’m trying to make it so that we can just make copies of one folder with the functional specs and the QA plan and use that as a sort of automated process. I’m running into the issue that Excel links need to be absolute so it’ll break the moment the first copy of the folder is made.