| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically run a macro everyday | Excel Discussion (Misc queries) | |||
| Display Date that does not change everyday. | Excel Discussion (Misc queries) | |||
| Formula help ... moving to next cell everyday | Excel Worksheet Functions | |||
| code for program run once everyday | Excel Programming | |||
| auto download file everyday | Excel Programming | |||
Threaded Mode
