Automating Find & Replace

Originally Posted by greggpetersen75

You should not be getting an error if the MasterSheet.xlsm is open and Project_Master_Template.xlsx is closed and they are in the same folder. Did you change the name of the Project_Master_Template.xlsx in anyway?

Thanks,

Gregg

Hey Gregg,

Sorry but I did not change a thing. When I click on the replace button I get this error. Note in the picture both files are on my Desktop and downloaded directly from this site as-is.

Screen Shot 2014-05-07 at 10.31.23 AM.jpg

If I click debug it takes me to the syntax line:

Set TemplateWorkbook = Workbooks.Open(Filename:=ThisWbk.Path & "\Project_Master_Template.xlsx")