Hi all. Got what will seem like an unusual situation: almost no Windows experience, and an severely limited target user.

Basically I've been using VBA in Office 2007 to do some database stuff, data crunching, XML stuff, etc. I've been making little worksheets and macros on my own time, after work, and frankly haven't been learning much about Windows development in general.

No problem there, really, as long as I don't need to use any tool or development stuff that's not already installed on the machine. Yes, our IT department is that rigid. and pretty much staffed by people with no IT background. Hence, if it's not in our corporate installation, it doesn't exist. (I know that there are some add-ons that I can use in Excel like the RegEx object, so some minor mods can be possbile...). This is a tech-phobic company.

Up til now I've been okay with that. However I've been getting to the point where the lack of features like exception handling is bothering me, a lot.

Apparently I'm stuck with the VBA On On Error Goto, and (to my knowledge) can't implement an error-handling system that I like. (BTW, is there a way to pass a goto label as a variable to a function? Or are there preprocessor macros?).

Now VB.net seems to have all the features I want, such as exception handling, and inheritance, and so forth. However, I'm unsure has to how to develop and/or distribute anything in VB.net with our setup.

At home my Macs (yes, I'm from that side) have Windows running in a virtual box ready to go. Is it possible for me to develop in VB.net at home (via Visual Studio?) and make worksheets that I can run at work with our limited Office users? It seems like I would have to create some kind of external application in VB.net that would communicate with Excel (?) but I don't know if it's possible, or how to check for the capabilities I need.

Also, is the Mac version of Office relevant at all to this?

T-I-A