Results 1 to 2 of 2
  1. #1

    Opening Workbooks with embedded automacros

    *** Edited Geoff W- point to <A target="_blank" HREF= =expanded&sb=5&vc=1>cross-post in VBA forum</A> ***

    I have a really tricky Catch22 problem.
    I have a AutoOpen Macro embedded in a Template.
    The Template is used to create a Quote.
    The PriceList.xls from which the information is gathered for the Quote has a macros which references the workbook (XXXX1 no extension) as created by the template (XXXX.xlt)
    This is OK so far.
    I then create and save the Quote minus some confidential pricing info.
    I also save a copy of the Workbook as WSYYY.xls used to create the Quote so the user can amend it latter and generate a new Quote.


  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts

    Re: Opening Workbooks with embedded automacros

    sounds like making your template into an add-in would be the first step to solving your problem.
    Q211563: XL2000: How to Create an Add-in File
    will start you on your way.
    Basically - you can run the functions in your addin on your file. Which prevents the kind of problems you are describing.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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