Dear Excel-specialists,
I have a question.
I have a script that opens all source files in a directory (Excel sheet with the same format) and copies the content from a specific range to a destination Excel sheet.
This script works fine (created with the great support of a member of this forum), but as mentioned in the title, this script also removes the formulas in the source files.
This even happens with the command --> ActiveWorkbook.Close SaveChanges:=False or --> ActiveWorkbook.Close False
I checked where the change in the formulas happen, and I think that this is the suspect (.Range("R7:S500").Value = arr ), but I am not quite sure.
Can anybody help me with this question? Unfortunately, I cannot share the Excel files because this is company confidential information (sorry for that/normally I add examples).
Please Login or Register to view this content.
Bookmarks