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

RBS


"Jeff" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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.