I'm using PATH reader and filecopy to make copies of excel files for a monthly archive process. It works great except one small issue - there's a sheet in each file that's linked to another excel file that gets updated every month with new data. The purpose of the archive is to create a snapshot of each month's dataset. Normal process is create a copy of each file manually, rename the file, then open and copy/paste values of the linked sheet, then save. I was hoping to fully automate this process. I've at least automated the copy/rename steps. Is there anyway of removing the formulas and writing the excel with values only?
+20- Contributor
Try making a copy like you're doing now with the Filecopy. And then read the sheet in that you're having issues with and overwrite the existing sheet.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.