Is it a way to schedule an excel spreadsheet to update automatical

[Jeff]

Hi all,
I'd like to have my spreadsheet to update automatically (don't know if
that's possible).
In order to do so, it needs to be able to do the following:

1) Is it a way to pass it arguments when lauching Excel, e.g. file name,
list of parameter such as date, mode, ..etc? Currently, the update is
triggered by clicking a commandbtn, if there is a way to pass in arguments
maybe I can get that to update automatically at a scheduled time (using a
batch file)?
2) print out 2 preselected area (2 different sections in the same
spreadsheet).


Any help will be greatly appreciated.

[upstate_steve]

Regarding scheduled updates, it's easiest to do this through Windows' Scheduled Tasks. It's accessible through Control Panel.

You would schedule Windows to open an Excel file and have your code run on the Workbook_Open() event for that file.

[ben]

ok i'm not sure exactly what you are asking, what do you mean by passing in
arguments, what are you trying to pass and how? yes you can schedule
lookup in help the
application.ontime keyword
this of course requires that the excel document in question be open.
however, you can use the windows scheduled settings to place that workbook on
a schedule to load and place the desired macro into the workbook_open
event.... this requires that macros be set to low, or you have the project
signed and trusted, to enable automation.

"Jeff" wrote:

> Hi all,
> I'd like to have my spreadsheet to update automatically (don't know if
> that's possible).
> In order to do so, it needs to be able to do the following:
>
> 1) Is it a way to pass it arguments when lauching Excel, e.g. file name,
> list of parameter such as date, mode, ..etc? Currently, the update is
> triggered by clicking a commandbtn, if there is a way to pass in arguments
> maybe I can get that to update automatically at a scheduled time (using a
> batch file)?
> 2) print out 2 preselected area (2 different sections in the same
> spreadsheet).
>
>
> Any help will be greatly appreciated.
>
>

[Tom Ogilvy]

Use the windows schedular to open the file (and open excel) at the specified
time

Put code in the workbook_Open event in the thisworkbook module to perform
the actions you required.

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events.

--
Regards,
Tom Ogilvy

"Jeff" <Jeff@discussions.microsoft.com> wrote in message
news:CFEBA056-9B0F-438D-A595-B4C5B9263DEF@microsoft.com...
> Hi all,
> I'd like to have my spreadsheet to update automatically (don't know if
> that's possible).
> In order to do so, it needs to be able to do the following:
>
> 1) Is it a way to pass it arguments when lauching Excel, e.g. file name,
> list of parameter such as date, mode, ..etc? Currently, the update is
> triggered by clicking a commandbtn, if there is a way to pass in arguments
> maybe I can get that to update automatically at a scheduled time (using a
> batch file)?
> 2) print out 2 preselected area (2 different sections in the same
> spreadsheet).
>
>
> Any help will be greatly appreciated.
>
>

[Jeff]

Guys,
Thanks for the replies. Sorry that I should have given more details.

I can't really put the code on open, it's because one of the tasks is to
print all the reports (over 80 of them), and printing on open isn't going to
work.

I am wondering if there is a way to pass in arguments (before the
spreadsheet is even lauched (e.g. c:\..\excel.exe test.xls printMode
date=12/31/04) things along that line. I know I can schedule an excel
spreadsheet to launch using scheduler, but not sure if I can pass in
arguments (variables) so the spreadsheet knows to perform some specific
actions.


Thanks

"Tom Ogilvy" wrote:

> Use the windows schedular to open the file (and open excel) at the specified
> time
>
> Put code in the workbook_Open event in the thisworkbook module to perform
> the actions you required.
>
> http://www.cpearson.com/excel/events.htm
> Chip Pearson's page on events.
>
> --
> Regards,
> Tom Ogilvy
>
> "Jeff" <Jeff@discussions.microsoft.com> wrote in message
> news:CFEBA056-9B0F-438D-A595-B4C5B9263DEF@microsoft.com...
> > Hi all,
> > I'd like to have my spreadsheet to update automatically (don't know if
> > that's possible).
> > In order to do so, it needs to be able to do the following:
> >
> > 1) Is it a way to pass it arguments when lauching Excel, e.g. file name,
> > list of parameter such as date, mode, ..etc? Currently, the update is
> > triggered by clicking a commandbtn, if there is a way to pass in arguments
> > maybe I can get that to update automatically at a scheduled time (using a
> > batch file)?
> > 2) print out 2 preselected area (2 different sections in the same
> > spreadsheet).
> >
> >
> > Any help will be greatly appreciated.
> >
> >
>
>
>

[RB Smissaert]

One way of passing these arguments would be to add them to the Window task
as comments.
If you get the superb .dll file tskschd.dll, written by Edanmo Morgilllo:
http://www.mvps.org/emorcillo/vb6/grl/index.shtml
this can be done quite easily.
If you have several arguments you will have to add them as comments
separated by for example comma's and then
read the comment into a string variable and do a split with the Split
function.
Another way would be to have a workbook (could be an add-in) with some
arguments written to a sheet and this
workbook will then read the arguments and launch your other workbook.

RBS


"Jeff" <Jeff@discussions.microsoft.com> wrote in message
news:A52B3871-8987-49F4-9525-9B1AAE2D8F66@microsoft.com...
> Guys,
> Thanks for the replies. Sorry that I should have given more details.
>
> I can't really put the code on open, it's because one of the tasks is
> to
> print all the reports (over 80 of them), and printing on open isn't going
> to
> work.
>
> I am wondering if there is a way to pass in arguments (before the
> spreadsheet is even lauched (e.g. c:\..\excel.exe test.xls printMode
> date=12/31/04) things along that line. I know I can schedule an excel
> spreadsheet to launch using scheduler, but not sure if I can pass in
> arguments (variables) so the spreadsheet knows to perform some specific
> actions.
>
>
> Thanks
>
> "Tom Ogilvy" wrote:
>
>> Use the windows schedular to open the file (and open excel) at the
>> specified
>> time
>>
>> Put code in the workbook_Open event in the thisworkbook module to perform
>> the actions you required.
>>
>> http://www.cpearson.com/excel/events.htm
>> Chip Pearson's page on events.
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>> "Jeff" <Jeff@discussions.microsoft.com> wrote in message
>> news:CFEBA056-9B0F-438D-A595-B4C5B9263DEF@microsoft.com...
>> > Hi all,
>> > I'd like to have my spreadsheet to update automatically (don't know
>> > if
>> > that's possible).
>> > In order to do so, it needs to be able to do the following:
>> >
>> > 1) Is it a way to pass it arguments when lauching Excel, e.g. file
>> > name,
>> > list of parameter such as date, mode, ..etc? Currently, the update is
>> > triggered by clicking a commandbtn, if there is a way to pass in
>> > arguments
>> > maybe I can get that to update automatically at a scheduled time (using
>> > a
>> > batch file)?
>> > 2) print out 2 preselected area (2 different sections in the same
>> > spreadsheet).
>> >
>> >
>> > Any help will be greatly appreciated.
>> >
>> >
>>
>>
>>

[Jeff]

RB,
That's exactly what I am looking for. However, that's an invalid link,
Edanmo is not listed as Excel MVPs anymore.
Do you have another link or another dll that will do the same thing?

Thanks

"RB Smissaert" wrote:

> One way of passing these arguments would be to add them to the Window task
> as comments.
> If you get the superb .dll file tskschd.dll, written by Edanmo Morgilllo:
> http://www.mvps.org/emorcillo/vb6/grl/index.shtml
> this can be done quite easily.
> If you have several arguments you will have to add them as comments
> separated by for example comma's and then
> read the comment into a string variable and do a split with the Split
> function.
> Another way would be to have a workbook (could be an add-in) with some
> arguments written to a sheet and this
> workbook will then read the arguments and launch your other workbook.
>
> RBS
>
>
> "Jeff" <Jeff@discussions.microsoft.com> wrote in message
> news:A52B3871-8987-49F4-9525-9B1AAE2D8F66@microsoft.com...
> > Guys,
> > Thanks for the replies. Sorry that I should have given more details.
> >
> > I can't really put the code on open, it's because one of the tasks is
> > to
> > print all the reports (over 80 of them), and printing on open isn't going
> > to
> > work.
> >
> > I am wondering if there is a way to pass in arguments (before the
> > spreadsheet is even lauched (e.g. c:\..\excel.exe test.xls printMode
> > date=12/31/04) things along that line. I know I can schedule an excel
> > spreadsheet to launch using scheduler, but not sure if I can pass in
> > arguments (variables) so the spreadsheet knows to perform some specific
> > actions.
> >
> >
> > Thanks
> >
> > "Tom Ogilvy" wrote:
> >
> >> Use the windows schedular to open the file (and open excel) at the
> >> specified
> >> time
> >>
> >> Put code in the workbook_Open event in the thisworkbook module to perform
> >> the actions you required.
> >>
> >> http://www.cpearson.com/excel/events.htm
> >> Chip Pearson's page on events.
> >>
> >> --
> >> Regards,
> >> Tom Ogilvy
> >>
> >> "Jeff" <Jeff@discussions.microsoft.com> wrote in message
> >> news:CFEBA056-9B0F-438D-A595-B4C5B9263DEF@microsoft.com...
> >> > Hi all,
> >> > I'd like to have my spreadsheet to update automatically (don't know
> >> > if
> >> > that's possible).
> >> > In order to do so, it needs to be able to do the following:
> >> >
> >> > 1) Is it a way to pass it arguments when lauching Excel, e.g. file
> >> > name,
> >> > list of parameter such as date, mode, ..etc? Currently, the update is
> >> > triggered by clicking a commandbtn, if there is a way to pass in
> >> > arguments
> >> > maybe I can get that to update automatically at a scheduled time (using
> >> > a
> >> > batch file)?
> >> > 2) print out 2 preselected area (2 different sections in the same
> >> > spreadsheet).
> >> >
> >> >
> >> > Any help will be greatly appreciated.
> >> >
> >> >
> >>
> >>
> >>
>
>

[RB Smissaert]

Can't find any download site now.
If you want I can mail you the zipped file.

RBS


"Jeff" <Jeff@discussions.microsoft.com> wrote in message
news:F71AEFE5-EAB3-4853-9393-0D8C97C9812F@microsoft.com...
> RB,
> That's exactly what I am looking for. However, that's an invalid link,
> Edanmo is not listed as Excel MVPs anymore.
> Do you have another link or another dll that will do the same thing?
>
> Thanks
>
> "RB Smissaert" wrote:
>
>> One way of passing these arguments would be to add them to the Window
>> task
>> as comments.
>> If you get the superb .dll file tskschd.dll, written by Edanmo Morgilllo:
>> http://www.mvps.org/emorcillo/vb6/grl/index.shtml
>> this can be done quite easily.
>> If you have several arguments you will have to add them as comments
>> separated by for example comma's and then
>> read the comment into a string variable and do a split with the Split
>> function.
>> Another way would be to have a workbook (could be an add-in) with some
>> arguments written to a sheet and this
>> workbook will then read the arguments and launch your other workbook.
>>
>> RBS
>>
>>
>> "Jeff" <Jeff@discussions.microsoft.com> wrote in message
>> news:A52B3871-8987-49F4-9525-9B1AAE2D8F66@microsoft.com...
>> > Guys,
>> > Thanks for the replies. Sorry that I should have given more
>> > details.
>> >
>> > I can't really put the code on open, it's because one of the tasks
>> > is
>> > to
>> > print all the reports (over 80 of them), and printing on open isn't
>> > going
>> > to
>> > work.
>> >
>> > I am wondering if there is a way to pass in arguments (before the
>> > spreadsheet is even lauched (e.g. c:\..\excel.exe test.xls printMode
>> > date=12/31/04) things along that line. I know I can schedule an excel
>> > spreadsheet to launch using scheduler, but not sure if I can pass in
>> > arguments (variables) so the spreadsheet knows to perform some specific
>> > actions.
>> >
>> >
>> > Thanks
>> >
>> > "Tom Ogilvy" wrote:
>> >
>> >> Use the windows schedular to open the file (and open excel) at the
>> >> specified
>> >> time
>> >>
>> >> Put code in the workbook_Open event in the thisworkbook module to
>> >> perform
>> >> the actions you required.
>> >>
>> >> http://www.cpearson.com/excel/events.htm
>> >> Chip Pearson's page on events.
>> >>
>> >> --
>> >> Regards,
>> >> Tom Ogilvy
>> >>
>> >> "Jeff" <Jeff@discussions.microsoft.com> wrote in message
>> >> news:CFEBA056-9B0F-438D-A595-B4C5B9263DEF@microsoft.com...
>> >> > Hi all,
>> >> > I'd like to have my spreadsheet to update automatically (don't
>> >> > know
>> >> > if
>> >> > that's possible).
>> >> > In order to do so, it needs to be able to do the following:
>> >> >
>> >> > 1) Is it a way to pass it arguments when lauching Excel, e.g. file
>> >> > name,
>> >> > list of parameter such as date, mode, ..etc? Currently, the update
>> >> > is
>> >> > triggered by clicking a commandbtn, if there is a way to pass in
>> >> > arguments
>> >> > maybe I can get that to update automatically at a scheduled time
>> >> > (using
>> >> > a
>> >> > batch file)?
>> >> > 2) print out 2 preselected area (2 different sections in the same
>> >> > spreadsheet).
>> >> >
>> >> >
>> >> > Any help will be greatly appreciated.
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>