Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Custom Document Property to identify xls files not yet process
I have a macro that goes through each spreadsheet in a folder and formats the
sheet. I'd like to have the code first check to see if there is a Custom Document Property and if so if it is set to True (this will tell the macro to close the file and move to the next one - the current one has already been formatted). If it doesn't find the property (or if the property is set to false) it would format the file, then add the property (or set it to true). Can this be done via VB? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to default WritePassword under excel workbook property for any files as long as those files are the offsprings of the parent file | Excel Programming | |||
Putting the document number custom property in workbook | Excel Programming | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
Process excel files, suppress alerts | Excel Programming | |||
Identify Document Being opened from an Add-In using Auto_Open? | Excel Programming |