noviceSoFar
Programmer
I have developed an Excel spreadsheet that generates a mail merged Word document with certain cells acting as the data for the mail merge. That works fine. The problem comes when the user wants to save the Excel file to another directory or drive. If its on the same computer, no problem as long as you can access the template Word document. But if the user saves the Excel file to, let's save a USB drive, I want the mail merge Word document to be copied at the same time and a certain cell in Excel to indicate what directory the files were last saved to. Is that possible?
Is there a way to record in a cell where the user saved to last? I can get the rest if that is possible.
Is there a way to record in a cell where the user saved to last? I can get the rest if that is possible.