LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to open a list of excel files and get update, then close it?

I get 10 excel files, 1.xls, 2.xls, 3.xls, ... 10.xls, summary.xls
I need to open each file, get update and close it in ascending order.
Does anyone have any suggestions to performance this tasks automatically
through one action? if not, I have to update each file manually, which takes
me 30 minutes to do that. Does anyone have any suggestions?
Thank you in advance
Eric
 
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
Why excel close all files when I just want to close one files hon123456 Excel Discussion (Misc queries) 2 December 8th 10 12:12 PM
Cannot open files in Most Recently Used List Suzan Excel Discussion (Misc queries) 3 July 29th 06 11:32 PM
fix for open/close files problem Patricia Shannon Excel Discussion (Misc queries) 0 April 25th 06 04:21 PM
fix for open/close files problem Patricia Shannon New Users to Excel 0 April 25th 06 04:21 PM
Hyperlinks to files open and then close instantaneously Rford626 Excel Discussion (Misc queries) 0 March 6th 06 10:30 PM


All times are GMT +1. The time now is 09:46 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"