Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 236
Default Auto run Macro when file is replaced daily?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I get old replaced excel file Mohammed Ali Excel Discussion (Misc queries) 1 April 1st 10 07:13 AM
Auto Create an Excel Backup File on a Daily Basis igbert Excel Discussion (Misc queries) 1 October 2nd 09 09:16 PM
Can a replaced excel file be recovered? Tom Moja Excel Worksheet Functions 1 September 3rd 07 10:33 PM
Auto save replaced my original file and now I need the original? Hols Excel Discussion (Misc queries) 1 August 15th 05 10:34 PM
Macro to copy daily text file Cheryl[_4_] Excel Programming 1 May 27th 04 05:46 AM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"