Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine .textorproperty and select case
I have a series of files to read into a
program. The way that the files get processed depends on what type of information is contained within that file. The only way to determine what type of file it is (meaning the type of information and the structure of that information) is based on what information is contained in the header of that file. Specifically, I'm looking for particular words: "Budget" or "Actual" AND "By Month" or "By Year" "Valids" or "Combos" "$" or "Stats" Is there some way to combine the .textorproperty and select case to make this check quickly. It would save me a lot of time because as it is now, I have to have several independent loops to process each of these files when in fact if I had the info above, it could be much less. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Case ignored | Excel Worksheet Functions | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Need help on Select Case | Excel Worksheet Functions | |||
Select Case | Excel Programming | |||
FileSearch for a TextorProperty with a wildcard | Excel Programming |