Hi there,
The approach I would probably take with this (and I'm not saying this is the only, right or best way) is to develop it in Excel first, then convert it to VBS afterwards. That way you get the benefit of all the debugging suite without guessing where your code went wrong. The secret is to convert everything to a late bound version for the VBS script.
Do you have any programming experience at all, and have you got any of this working in Excel yet?
Bookmarks