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: 23
Default Closing files by a macro

Hi all


I have 20 excellworkbooks open with diferent names.

Problem is to save and close theese files as fast as possible by a
macro.

As it is now, one file has to be saved and closed before I can run the
macro again manually.
Is the a vbariable there can be used to automatic restart the macro???

anyone have an idea??


The macro is placed in Personal.xls.



regards


kurt

 
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
Closing Files CLASSC Excel Discussion (Misc queries) 1 November 2nd 09 06:05 PM
Closing Files Diana Heimberger Excel Discussion (Misc queries) 3 September 1st 06 06:45 PM
closing all files colt Excel Programming 4 August 23rd 06 01:30 PM
Closing files and saving files dan Excel Worksheet Functions 0 August 15th 06 04:07 AM
Save files before closing MasterP Excel Discussion (Misc queries) 1 December 30th 05 08:13 PM


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