Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an object property that will return the file type?
I'm writing a formatting macro that I only want to run on .txt or .csv files.
This mostly a safety feature for other users so if they accidentally press the wrong combo of hot keys they don't have a macro run that will ruin the spreadsheet they are currently working on. Is there an object property I can write into the code that will return the file type of the active workbook? ActiveWorkbook.FileType doesn't work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get the Data Type of a Property | Excel Programming | |||
problem:Structure with Object reference (TYPE...END TYPE) | Excel Programming | |||
Objects with .type property | Excel Programming | |||
Return value of Property Get when using enumerated type | Excel Programming | |||
How to find what object type is returned from Selection property ? | Excel Programming |