| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Sep | Nov » | |||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
"Validating" file names is one of those things that no matter how hard you try you'll never get it 100% right. There are a loads of reasons when a file might not save, even if the name is valid, acess rights, disk space, problems with the file it's self, network issues...
Basically you have to trust [...]
JP asked if I could expand on the Cancel post. I thought that I had already posted a DoEvent example, but I couldn't find it on this blog, although when I dug out the org. file it did have a link to a blog post that didn't work!!!! Maybe my blog is losing content!
Anyway here [...]
I like to allow users the opportunity to cancel out of long loops if they need to. I use a global variable, something like gbCanacel, which gets set to True when the user clicks the Cancel button.
Then my looping checks for this with an if statement, normally the last thing inside the next/loop statement. [...]
I've added a few more methods to the fuzzy logic ss. Namely Jaro-Winkler (nice name!) and a Longest Common Subsequence fucntion and a Dice Coeffient function. The last 2 dont seem to be that useful, but what the hay, you never know when you might just need a Dice Coeffient right!
Heres the ss. Fuzzy Logic [...]