"Greg Maxey" wrote:
> This is a long post with multiple questions. Please don't be discouraged
> and feel free to answer all or part. Thank you.
>
I have not really worked with 2007 VBA or XML yet... In fact, I have looked
into 2007 because I was curious, but my working environment has not yet
allowed me to really take the plunge yet...
As I read your post, something did occur to me, and I tought that it might
be of interest to you, so here we go!
>
> 1. I am not very confident of my process for populating the two arrays with
> the data needed for the callbacks. My goals is to find the simplest way to
> make the data customizable to the user and accessible to the the callback.
> By putting the data in a table contained in the template. All the user needs
> to do is open the template and edit the table. Once that is done, then when
> the template loads the the compiler has to get to it. AutoExec is the only
> event that I know of that fires when a template is loaded. Is this correct
> and is this the best way?
>
I do not like the idea of telling users to open a template... Too many
things could go wrong...
If I were developping such a customizable tool. I would include a Ribbon
button called "Customize Entries" (or whatever is appropriate). The button
would get the information from the template, display it in a table in a new
unsaved document, then the user would edit that document. this document, when
active, would have something like a MACROBUTTON labelled "Done" or some such
label (I guess it could be an ActiveX button instead). The user would click
on that to save the changes back to the template. (Or the button could be on
the Ribbon instead, excepts that this is more difficult becasue if the user
decides to give up and not close the document properly or in an unexcepted
way, you may be stuck with a useless Ribbon button).
Finally, since you already have the code to populate the dropdowns on the
ribbon, I guess you would need to execute that code to update the ribbon as
soon as the user has finished updating the data.
Just my 2 cents!