Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Thanked 0 Times in 0 Posts

    Workbook Duplication (97)

    I need to take a workbook with many sheets and make it into many workbooks each with identical modules, userforms, sheet based controls, and event handlers. I had thought about just running a DOS script to copy a "master" workbook and rename each copy but I was wondering if there is any better way to do this?

    I know how to use VBA to move the actual data but duplicating everything else in detail is unfamiliar territory.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Weert, Limburg, Netherlands
    Thanked 0 Times in 0 Posts

    Re: Workbook Duplication (97)

    You would benefit from the SaveCopyAs method. Look in VBA Help. It saves a copy of the specified workbook without changing the name of it's source:
    Dim iCount As Integer
    For iCount=1 to 10
    ActiveWorkbook.SaveCopyAs "CataCopy number " & Format(iCount),"00") & ".xls"
    Next iCount
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    Professional Office Developers Association

Posting Permissions

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