LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to make a back-up .xlk file tony Excel Discussion (Misc queries) 3 September 29th 06 04:59 PM
opening an excel file opens a duplicate file of the same file skm Excel Discussion (Misc queries) 1 December 7th 05 05:52 PM
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz Daniel Excel Worksheet Functions 1 July 7th 05 03:52 AM
i received a file that reads powerpoint document file file exten. CCAROLACEREC Excel Discussion (Misc queries) 1 December 4th 04 05:02 PM


All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"