Does anyone know how to get excel and VB to play nice???
I am new to VB but have done basic c++ so am not too lost!
My problem is i have a .txt file containing names. I need to have this list randomised!
People have sugested that i do this via excel. Good plan i thought (so very very wrong!)
So i have conviced VB to move the names there but then what???
Someone on another forum said to use =rand() which works when i manually put it in the cell. However VB just likes adding it to the end of the persons name
Any sugestions on getting it working with or with out Excel would be greatly appreciated