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: 2,646
Default SaveAs without closing original workbook

Hi All,

I want to clone a workbook in several copies with different file names, and
also I want to keep the original workbook open during the process and
activate it again at the end of the process. SaveAs works, but closes the
original.

Thanks,
Stefi

 
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
SaveAs closing file without firing event WorkBook_beforeclose PFS Excel Programming 1 November 2nd 06 10:49 PM
copying worksheets to a new workbook without formulae referencing original workbook [email protected] Excel Programming 2 October 16th 06 07:31 PM
Keep original wkbk open after SaveAs? Ed Excel Programming 2 May 2nd 05 10:12 PM
Copy file and closing original Rob Excel Programming 3 May 8th 04 01:37 PM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM


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