ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code to transfere all cell data in one old file to a new open? (https://www.excelbanter.com/excel-programming/331432-code-transfere-all-cell-data-one-old-file-new-open.html)

Maria J-son

Code to transfere all cell data in one old file to a new open?
 
Hi,

When I develop new releases/versions of my excel tool, I have some templates
and example files in the old vesrions. There is a lot of work to copy paste
all data on all sheets to the new file version.. I think I need to create a
macro, where I can point out a file with the source data to transfere and
without open it, the the macro paste it to the one I have open. Just put
values and formulas in the same cell references in my new file.

Does anybody know a good routine to share with me?

/Kind regards





All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com