Thanks for the input so far!
Ok...so the lawyers use word. We have custom templates created with VBA for the way documents need to be presented. So if they are doing something involving litlgations, they can select the litigation template and it sets all the font, line spacing etc etc for the document. So we need VBA to created these templates and manage them, and insert menu's into word to they can easilt select a desirec template etc.
There are also other additions we will be adding like being able to click on a selected ending for certain documents and it inserts it instead of them having to retype the same standard conclusion every time.
With some documents, it needs to insert a specific letter head or footer automatically...so ja...we need to use VBA for this.
Some lawyers open an Excel file in word and it messes up. Then we get helpdesk calls saying whats going on etc etc. So ja...they dont even realise what they do sometimes...so VBA will also be used to check the right file is opened with the right software...basically need to check for user error...
No disrespect to lawyers...but they are lazy...and we need certain additions added onto Word to make things easier for them. Understandable I guess.
I wanted to use Visual Studio Tools for Office, but I see its only for Office 2007...and we have Office XP. So Im gonna stick to VBA for now...as they need it yesterday....then will upgrade when we move to Office 2007.
So there ya go...the full story! If anyone has some input...PLEEZ share...thanks for the help thus far
![Wink :wink:](./images/smilies/icon_wink.gif)