Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using one file to make changes in another file
How would I go about using code in one excel file to change the contents of a
different file? I have a workbook for swimmers to keep track of times. It tracks their best times, and then compares the best time to a table of time standards. The issue is that the time standards change periodically, and I want to give users an update file that will update the time standards in the original workbook, without requiring them to re-enter all of their times. What I envision is having a sheet in the update file with the new time standards, and using vba to replace the old standards with the new ones. But I am open to other methods. In the target workbook, I have workbook structure protection, vba project protection, and worksheet protection. Also, the target time standards sheet is hidden. Thanks in advance for your help, ~ Horatio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make a back-up .xlk file | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions | |||
i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) |