Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mark files and sheets for identification
I am using VBA in Excel XP on Windows 2000.
I need to be able to identify particular files and sheets that reside in a particular directory so they can be associated with information that will be gathered programmatically. The users will be provided with a "base" file that contains a certain sheet on which my key information will be entered and stored by the users. The users of course will likely change the file names, add new sheets to the base file, change sheet names, add additional files in the target directory and so on. The users need the ability to use the basic Excel functions so instead of trying to lock Excel down, I placed a custom document property in the template file. My program will loop through all files in the directory and when my program opens each file it will check to see if the file contains this property, if so, then the program will know that this is a "good" file. Next, I changed the "codename" of the target sheet so that the program could ID that as well. Since most users only change the tab name of a sheet, I think the code name is pretty safe. Does anyone know of any other or better methods for marking these items in a way that typical users will not notice and will not (un)intentionally alter? Does anyone know of any drawbacks to using these methods I've described? Any and all advice welcomed, please post your suggestions. Thanks very much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving txt files with quotation mark delimiters | New Users to Excel | |||
Foot mark aka single quote mark? | Excel Worksheet Functions | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Graph on each sheet when I mark same cells on multiple sheets | Excel Discussion (Misc queries) | |||
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming |