Results 1 to 2 of 2
2001-04-23, 22:13 #1ralph_daviesGuest
Opening Workbooks with embedded automacros
*** Edited Geoff W- point to <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=vb&Number=33812&page=0&view =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.
2001-04-24, 00:24 #2
- 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