I’m kind of new to this. My company has a large qty of docs in Word and Excel which I need to batch process with a macro that will remove the footer. This format is required by a new document control software that is being adopted before the docs can be migrated to the database. I have managed to put together two macros (one in Word, one in Excel) that will cycle through the directory and removed the footers from the documents. It would be nice if I could as part of the cycle, save each document to a new location. I have tried something I found on the Web that is something like this in Word…. dc.Saveas (“C:\Dir\Sub etc. This method doesn’t seem to work. Can someone tell me if I am on the wrong track with this approach. Is there another code I am not aware of or have not encountered that would allow me to save these files (all of them) to a specific location?
