Results 1 to 2 of 2

Thread: Save and Close all workbooks in Excel 97

Threaded View

  1. Oct 6th, 2003, 12:34 PM #1
    Yesuslave
    Yesuslave is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2003
    Location
    Mt. Holly, NJ
    Posts
    31

    Save and Close all workbooks in Excel 97

    Hi all,

    I want to create a loop that saves each workbook in Excel 97 and then closes them. Preferably it would look like

    Do until ActiveWorkbooks = "" 'Or whatever the code for this is

    ActiveWorkbook.Save
    ActiveWorkbook.Close

    Loop

    The piece of code that I really need is the first bit, the Do Until part. Not really sure how to know that all of the workbooks have been dealt with.


    Thanks
    Last edited by Yesuslave; Jul 16th, 2022 at 07:20 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width