Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you're on XP go to:
Start-Programs-Accessories-System Tools-Scheduled Tasks From there you can run a program to run on a periodic basis. That program could be Excel, or it could be VBScript, or a bat script. For starters see what you can do to put DLYPROChdr in an Excel Auto_Open() Sub. If you have no control over PROCESS.xls and can't add a Macro to it then you have to go down the VBScript road. In VBScript open PROCESS.xls, add your own module, and call a Macro that calls DLYPROChdr from there. The VBScript might look like: Set objXL=Create("Excel.Application") objXL.Visible=True oVBC = ojbwb.VBProject.VBComponents Set M = oVBC.Import("SomeModule.bas") objwb.Application.Run "SomeModule.DLYPROChdrCallerYouWriteYourself" tos the VBA that creates headers and footers and instead open a template that already has to headers and footer created. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I get old replaced excel file | Excel Discussion (Misc queries) | |||
Auto Create an Excel Backup File on a Daily Basis | Excel Discussion (Misc queries) | |||
Can a replaced excel file be recovered? | Excel Worksheet Functions | |||
Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
Macro to copy daily text file | Excel Programming |