1. I'd change LookAt:=xlPart to LookAt:=xlWhole and then you don't need another macro

2. Worksheet "Input" should be in the workbook with the macro ('Replaces_1.xlsm' in my attachment)

3. "I only have the input sheet in the one I want to convert" -- then why are you looping through all worksheets??

4. "I would prefer it to be in c:\midstate\replacedata.xlsx." -- The 'database' ('ReplaceData.xlsx' in my attachments) can be anywhere that you have permissions. The Workbook.Open Filename:= … just has to match