Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a histogram that updates when I filter the input ran | Excel Worksheet Functions | |||
How do I create a sheet in Excel that updates itself from other sh | Excel Worksheet Functions | |||
How do I create spreadsheet that automatically updates numbers/va. | Excel Discussion (Misc queries) | |||
How to view other's reply in search mode... | Excel Programming | |||
How to create two validation lists that modify each other's value? | Excel Programming |