Thread: How transfer data from one file to another other with VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
  
Posts: 78
Default How transfer data from one file to another other with VBA
My Excel (97 newer) application allows user to "Save As" any number of files
from the main program. When the main program is updated, however, the
existing saved files are not updated. So I would like to make it easy for
the user to auto-fill the main program with data entries made in any one
saved file. The cell numbers and ws names are consistent. Can anyone please
advise the best procedure. Thank you.

Jim Kobzeff

Reply With QuoteReply With Quote