View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maria J-son Maria J-son is offline
external usenet poster
 
Posts: 17
Default 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