Word VBA
in [Word]
|
Template lookup to SQL Server DB value I want to build a module that does the following for multiple Word templates: 1. Request the user to input a policy# 2. Look up the policy info in a table in SQL Server Database with the policy # 3. Populate fields in the template (name, address, etc) What is the best way to accomplish this? The data I need is in ... 28 Dec 2009 05:18
Distribution of Word templates with macros The "workaround" I have found to overcome all the distribution issues is to send the certificate file with the digital signature to all my recipients and ask them to install it as the trusted authority. Following that, Word (both 2003 and 2007) are set to trust this authority. This has to be done only once. Al... 22 Dec 2009 17:04
creating new excel workbook in code without opening excel Can anyone tell me if it is possible to create a new workbook with vba in word without opening excel. I have an excel template (myXLtemplate.xltm), I would to create a new file based on the excel template and save it to a new location. Working in office 2007. Thanks in advance for any suggestions. ... 22 Dec 2009 17:04
Cant change FirstPageTray of Word Document I am getting below error while assinging the Printer Tray. System.Runtime.InteropServices.COMException (0x800A1200): Value out of range at crosoft.Office.Interop.Word.PageSetup.set_FirstPageTray(WdPaperTray prop) here is the code I wrote. With WordApp.ActiveDocument.PageSetup .Firs... 22 Dec 2009 14:51
Blank Userform Hi all, I have a slight problem, I have some code which adds rows with formfields in to a table in a protected form. These formfields have text in which is dependant upon users ticking checkboxes. Before adding the rows my code checks to see if particular rows have already been added to the table so that t... 22 Dec 2009 15:58
run macro after userform unloads I have a complicated userform contained within a template. Once the userform is completed and the OK command button is selected the userform merges and populates. Within the template I have a series of cross references which I would like updated once the document populates although I'm not sure how to do th... 22 Dec 2009 15:58
Using code to hide format of form field until needed. I have a form in Word 2003 that will serve two purposes. It can be filled out electronically or printed and hand-written. I am using a calculated field, but do not want the "0" to print when it is used as a hand-written doc. Suggestions appreciated. ---------------- This post is a suggestion for Microsoft,... 21 Dec 2009 23:33
Office Supplemental Release (October 2009) Bill Coan passed me a link today containing information about change by MS that could affect how Content Controls interact with the XML datastore: The gist of the link is this: "Microsoft has released a supplement for Office 2007 (October 2009). The following patch is required for the United States. The patch... 24 Dec 2009 08:35
Copiing styles to Normal.dotm In the Start-up folder for Word (2007) is a template that sets the Style 'Normal' (font and font size) for the normal.dotm. It sets the Style 'Normal' in the activedocument and copies this style to the Normal.dotm (to make sure everybody in the company has the right font and fontsize) The macro works fi... 21 Dec 2009 14:44
Two Templates, One Ribbon Tab? Can two templates modify the same ribbon tab? That is, I'd like to seperate functions into different templates but have any of those templates use the same ribbon tab. The result is that one tab might contain different groups depending on which template(s) are loaded. Is this possible? If so, how? ... 21 Dec 2009 14:44 |