Split

[Lars-Erik]

I wrote some code using the Split() function.
I use Visio 2007 myself, I've transfered the code to a different computer ( running Visio 2003 ).  Now I get an error saying it can't find the library. Doesn't Visio 2003 know the split function? Is there an easy way to write on myself so I don't have to change existing code using the Split function? Or is something else going wrong ?

Any thougts?

- Lars

[Visio Guy]

I've had this problem too, and I never remember exactly what I do to fix it.

1. Check your References in the VBA editor and see if anything looks weird.
2. Try replacing Split with VBA.Split and see if anything gets better.

It drives me crazy when I can't remember the exact answers! (that's why I added the forum, the 'Net can remember for me!)

[Lars-Erik]

VBA.Net does get reconized, but still causes an error :S
The refferences (althoug 12.0 is now 11.0) seem ok, just that it cant find the microsoft excel 12.0 i told it to load on my 2007 Visio (seems logical?)

Edit:
O well the Excel 12.0 that couldn't be found seemed to be the bad guy. I removed it and all is fine now. Odd, not being able to find the Excel 12.0 could cause this?!

- Lars

[Visio Guy]

I think that what you are seeing is a crappy VBA compile error. VBA is not happy because Excel is missing, and it somehow sees EVERYTHING as an error, so you end up thinking that Split is causing the problem. Weird.