Vizard and VBA
 

Okay, random question but I was wondering does anyone know how to run a vizard script from a vba module in excel.

I can open vizard and the particular script in question, just cannot get it to automatically run...

VR = Shell("C:\Program Files\WorldViz\Vizard4\bin\Vizard.exe C:\Users\Roisin\Desktop\Disc\DiscWorld.py")

The line above opens vizard, opens the script I wana run...


Apologies if this is completely the wrong area, but thought I'd give it a try !

Hi rmcconnell11,

What is it that you want to accomplish? If you want your program to run automatically, consider publishing it as an executable. If you want to automatically start a specific script with vizard, you could create a batch file (on a Windows computer at least). I'm not familiar with the vba module in excel, and this is not the best place to ask this question. Consider a forum specifically for excel.

The executable that runs Vizard scripts is winviz.exe. Try replacing "vizard.exe" with "winviz.exe" in your command.

Sorry just getting back to this work now, but thanks jeff that work perfectly!!! I was calling vizard rather than winviz! thank you so much