Opening an excel file using a script

Hi,

I have created a spreadsheet containing some macros.
I need to write a script of some sort that could run the spreadsheet (allowing the macros to run) on a scheduled basis.

does anyone know how I can do this?
also, is there a way of the system opening an excel spreadsheet without actually visibly doing so (no MS Excel being open etc)?

the macros int he sheet refresh data from an external source, and email a specified user.

thanks in advance,
Matt

matpj wrote:
> I have created a spreadsheet containing some macros.
> I need to write a script of some sort that could run the spreadsheet
> (allowing the macros to run) on a scheduled basis.
>
> does anyone know how I can do this?
> also, is there a way of the system opening an excel spreadsheet without
> actually visibly doing so (no MS Excel being open etc)?
>
> the macros int he sheet refresh data from an external source, and email
> a specified user.

Will a Scheduled Task (it's in the control panel) meet your needs?
Socks

hi,
thanks for the reply.
I looked at scheduled tasks, but that seems to just be for programs to execute on a schedule.
I need to run a file.
not sure if a batch file woudl do the job - I wouldn't know where to start with batch files.

I have tried running the file using a dos command. It opened Excel and opened the file, but still asked me if I wanted to enable macros etc.

i'm hoping for a solution that will open the file in the background, without displaying any alerts, and then close it..

thanks,
Matt

matpj wrote:
> hi,
> thanks for the reply.
> I looked at scheduled tasks, but that seems to just be for programs to
> execute on a schedule.
> I need to run a file.
> not sure if a batch file woudl do the job - I wouldn't know where to
> start with batch files.
>
> I have tried running the file using a dos command. It opened Excel and
> opened the file, but still asked me if I wanted to enable macros etc.
>
> i'm hoping for a solution that will open the file in the background,
> without displaying any alerts, and then close it..

As long as you have security set high enough to ask for
confirmation, it will ask for confirmation. It does not matter
how you run it. You need to turn security lower to get rid
of these warnings.
Socks