An executable file to run a VB script?

[Guest]

Is it possible to construct an executable file that will run from Windows XP
that will launch a VB script in Excel at regular intervals?

Ideally, I would like to be able to assign this .exe program to Windows Task
Scheduler in order to send data to other programs at assigned times.

Many thanks.

 

[Pegasus \(MVP\)]

Is it possible to construct an executable file that will run from Windows
XP
that will launch a VB script in Excel at regular intervals?

Ideally, I would like to be able to assign this .exe program to Windows
Task
Scheduler in order to send data to other programs at assigned times.

Many thanks.

If your script resides in Excel then the best place to ask
this question would be an Excel newsgroup. They might
tell you how to run a auto-starting VB program in Excel.
Your task is then to use the Task Scheduler to launch
Excel and open the spreadsheet containing the program.

 

[Guest]

Many thanks, I'll follow your suggestion

best wishes

Tony

 

[Newbie Coder]

Zakynthos,

In .NET you can add the Excel Interop Class which exposes the Excel programming
object that can run the VBA at regular times.

Better still create the code & export it to XLS format

Very simple