I now have a different solution.
In Excel I created the following macro:
Shell "CMD /C D:\Mine\Arkham_Horror\Mythos\rand.cmd", vbNormalFocus
In the rand.cmd file, I added two extra lines at the top:
The lines change drive and then directory, then the script runs.
When I run the macro, a randomised jpg is opened - voila!
I can now run this marco via a command button.
Instead of simply opening the jpg, i want it instantiated into the spreadsheet (or visio drawing), and at a spcific location.....