View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Horatio J. Bilge, Jr. Horatio J. Bilge, Jr. is offline
external usenet poster
 
Posts: 135
Default 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