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?
Page 1 / 1
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.