Opening an excel file using a script

[matpj]

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

 

[Puppet_Sock]

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

 

[matpj]

hi,
thanks for the reply.
I looked at scheduled tasks, but that seems to just be for programs t
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 t
start with batch files.

I have tried running the file using a dos command. It opened Excel an
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,
Mat

 

[Puppet_Sock]

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