Guest Zakynthos Posted August 10, 2007 Posted August 10, 2007 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.
Guest Pegasus \(MVP\) Posted August 10, 2007 Posted August 10, 2007 Re: An executable file to run a VB script? "Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message news:FA1DF420-0D91-4132-83F5-685E266D00B1@microsoft.com... > 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 Zakynthos Posted August 10, 2007 Posted August 10, 2007 Re: An executable file to run a VB script? Many thanks, I'll follow your suggestion best wishes Tony "Pegasus (MVP)" wrote: > > "Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message > news:FA1DF420-0D91-4132-83F5-685E266D00B1@microsoft.com... > > 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 Newbie Coder Posted August 10, 2007 Posted August 10, 2007 Re: An executable file to run a VB script? 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 -- Newbie Coder (It's just a name) "Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message news:FA1DF420-0D91-4132-83F5-685E266D00B1@microsoft.com... > 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. >
Recommended Posts