Thread: code to save the whole folder with a workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
  
Posts: 408
Default code to save the whole folder with a workbook
Hi All

Is it possible to change this code:
Sub SaveBackup()
ActiveWorkbook.SaveCopyAs "d:\MyBook.xls"
End Sub
to save a copy of the Folder in which is the Book-to back up not only
€śMyBook€ť but the whole current folder with the book?

Reply With QuoteReply With Quote