| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple file extensions causing issues
Our org converted to XL2007 and we have a LOT of legacy programs out there
that use/populate/manipulate multiple files. In the past, there was only one working file extension, XLS. Now, with our legacy files, there could be three: XLS, XLSX, XLSM (I know there are several other types, but these are the primary three that we would be using). Now, since there are several different file extensions, many of our programs will misfire when looking for target files. Anyone have any suggestions on how to deal with this neatly in code? I'd hate to have to set up an "If...Then..." everytime to try each file extension...any ideas? Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Phantom Objects causing issues | Excel Discussion (Misc queries) | |||
| $ dollar signs causing issues in Excel VBA - HTML | Excel Programming | |||
| xls spreadsheet constantly calculating causing navigation issues | Excel Worksheet Functions | |||
| If then statement causing value issues in Macros | Excel Programming | |||
| excel 2000 add-in causing delay issues | Excel Programming | |||
Threaded Mode
