View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kurt kurt is offline
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