ExcelBanter - Macro to run everyday???

I bet you meant Auto_Open (not autoexec).

Paul Grayson wrote:

Within excel you can create functions within the vba code, if you create a
funtion called "Autoexec" and within the function run the macro.

When you open the excel spreadsheet "Autoexec" function automatically runs,
therefore running your macro.

Then within windows there is a package called "Scheduled Tasks" create a
scheduled task to run the excel spreadsheet on a daily basis and it will open
the spreadsheet and then run the Autoexec function which in turn will run the
Macro.

hope this helps.

Paul

"Pete" wrote:

Paul, I was able to figure out how to have the spreadsheet automatically run
the macro I created when the specific spreadsheet is opened, buty I can't
seem to fugure out how to tell excel to do this automatically when the
program is open. can you please elaborate on your suggestion.

Thanks
--
Pete

"Paul Grayson" wrote:

Pete,

Create an autoexec function which will automatically run when you open excel
that runs your macro. The tell the windows scheduled tasks to open the excel
spreadsheet on a schedule of your choise

"Pete" wrote:

File = Excel 2003 File?

"URL;http://www.wistv.com/Global/category.asp?", Destination:= _
ActiveCell)
--
Pete

"Don Guillett" wrote:

What kind of file and what url?

--
Don Guillett
SalesAid Software

"Pete" wrote in message
...
Is there a way to have excel run a macro everyday either when the excel
program is opened or a certain time in the day with the program not open?
I
don't this the later is possible, but I know only a limited amount
information in programing.

I want to perform a web query everyday in a certain file, but I do not
want
to have to open that particular file everyday. Any guidence or help is
greatly apprech.
--
Pete

--

Dave Peterson