View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robs3131 robs3131 is offline
external usenet poster
 
Posts: 144
Default Can I create a file to send to other's that updates module 1?

Hi all,

I created a spreadsheet that a number of users have on their hard drives --
I'm wondering how I can make code updates to their files without actually
opening their files? I was wondering if there is a way that I can create a
"fix file" with the updated code that when the user clicks on a button in the
"fix file", the code in this "fix file" will do the following:

1 - Identify the file that needs to be updated (maybe by having a menu that
comes up that allows the user to navigate through their hard drive (like
windows explorer) and select and/or open the file that needs to be updated)
2 - Once the file on their hard drive is identified/open, the "fix file"
will copy the code that exists in say module 1 of the "fix file" and then go
to say module 8 of the user's file and paste over any existing code in module
8.
3 - The user's file will then save

Any help you can give me is appreciated! If there is something that exists
on the internet somewhere that details how to do this, that would be great.

Thanks.

--
Robert