LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Open Save & Close Macro

I have a workbook (Using Excel 2007 but file is saved in 2003 format) that a
bunch of other workbooks are linked to. Since this file is also linked to
other files, I need to make sure this one is up to date every morning. So
right now I open it, save it and close it each day. What is the easiest way
to automate this process? Is there a way to write the VBA and then save it in
a form that can be executed from XP's "Scheduled Tasks?" Or, do I need to
make a .bat file (and if so, what is the correct syntax).

I know it only takes me a few minutes to do this manually (takes a while for
all of the links to update), but every little bit of extra time is useful.
Thanks for the help.
 
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
Macro to open, Update links, save and close workbooks Anton Excel Discussion (Misc queries) 0 January 7th 10 03:18 AM
Open , Save, and Close Macro [email protected] Excel Programming 1 December 13th 07 03:41 PM
macro to run on first open after save and close pswanie Excel Programming 2 June 17th 07 07:44 PM
Open Save & Close All Files in Dir Diane Alsing Excel Programming 5 January 31st 05 07:47 PM
Automate open file, update links, run macro, close and save file Geoff[_7_] Excel Programming 2 August 26th 03 10:13 PM


All times are GMT +1. The time now is 03:12 AM.

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

About Us

"It's about Microsoft Excel"