Vizard and VBA

[rmcconnell11]

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 !

[Frank Verberne]

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.

[Jeff]

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

[rmcconnell11]

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