I want to split two words in a commandbarbutton (msoControlButton) caption to be on two lines. I tried this:
Set tlbSpell = Bar620.Controls.Add(msoControlButton)
tlbSpell.Style = msoButtonWrapCaption
tlbSpell.Caption = "Spell" & Chr(13) & "Check"
tlbSpell.OnAction =...
I have a large form with hundreds of formfields. I need to use a find and replace function, preferably Word's wdDialogEditReplace dialog to find and replace words or phrases in formfields only. I can invoke the dialog box from script, but to do so I have to unlock the entire document; thus...
I have an application I built in Word 2000 that has a custom toolbar that loads when the application opens. When I open the application in Word 2007 the toolbar is available in the Add-Ins Tab on the Ribbon. Does anyone know of a way to show the custom toolbar in the Add-Ins tab automatically...
Is there a way to change replication settings programmatically?
Our IT department is changing to a different server and we need to change replication settings to replicate to the new server. Here is their plan to convert.
"In order to make replication pages the users have to put the new...
I have the following code in an Excel Workbook. It works fine in Excel 2000 but not in Excel 2003.
Private Sub Workbook_Open()
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
Application.EnableAutoComplete = False
ActiveWindow.DisplayZeros = True
Worksheets("TIME...
Is there a way program Lotus Notes to look in two different places for the Notes ID File? We have multiple users using the same machine and those users move around within the state. Each user has access to an "H:\" drive on the statewide network. The Notes ID file has to be stored on the C:\...
I have a large Word XP document with lots of section breaks. I have created a Print userform that allows users to choose a portion of the document to print. Those portions correspond to section breaks in the documents. When the user selects a portion to print I send a print command to print...
I'm runing an entry script on a dropdown type formfield in Word that automatically expands the dropdown when the field is selected & the value of the field is 1. I don't want to expand the field if the user has been in the field before and has selected a value other than the first blank value...
I am using the ConvertToTable method in Word VBA to convert a tab and carriage return delimited text string into a table. This works very well, except when I have a lot of rows of data in the string to convert. When there is a lot of text and the table should continue on the next page the...
How can we add a Database Bookmark Icon to a user's workspace with a Lotus Script in Lotus Notes 6.5?
Our company is adding a new Notes database to our server and we need a way to bookmark the database on the Notes Workspace on all of our computers (about 2500) with a script that can be called...
Using a VBA command, how do I open an Excel Workbook, that requires a password to open?
I am creating an automated mailmerge project using VBA in Word. I'm using an Excel Workbook as the datasource, but the workbook requires a password to open. I either need to be able to send the password in...
How can I disable AutoFormat and AutoCorrect using VBA in Word XP and 2000? I can disable it and re-enable it in just XP or just 2000, but not both. My problem is this - I am building an application in Word that will be used in both Word 2000 and Word XP (versions 9 and 10). There are 4 extra...
Our company just installed Windows 2000 Service Pack 4 on our computers. Now the links at the top of VBA Help screens have disappeared. Instead of the links like Examples, See Also, Properties, Methods, etc., we all have pictue place holder frames. Anyone have any idea how to get these back.
How can I get Microsoft Forms 2.0 Object Library to autoload when Word starts up?
I am using "DataObject" from the Microsoft Forms 2.0 Object Library in my form scripts. These scripts have worked for months. Since the fix for the Worm attacks was installed last month Word has...
I'm trying to pass a paragraph of text from a formfield into a cell in a table for storage, then pull it back from the table cell into the original FormField. Similar to a database. For various reasons I can't use Access for this project because we don't have it, so I'm stuck with Word.
I...
I am using "CustomizationContext = ActiveDocument" in my scripts just before setting hot-keys. I have been using this for quite some time on lots of form templates that are used on several thousand computers in our agency with no problems. An associate got an new computer with...
Is there any way to format the text being entered into an inputbox in Word? I'm using an inputbox to get a password for a simple operation and would like to place **** instead of aaaa to add a little more security. I'd be happy to simply change the font to wingdings or something.
Is there a way to use a BeforePrint Event in Word 2000 without creating a new Class Module? I'm needing to run a script automatically when the user invokes a print command. Word did not inherently have a BeforePrint event available without creating a new Class Module to create the...
Is there a way to change all the objects (text, tables, drawing objects, etc.) in a Word document to orange rather than white when the "Blue Background, White Text" option is selected in Tools - Options - General?
I need to change Word forms to a night time color scheme using dark...
I have a document in Word with two sections. Section 1 contains form fields and is protected when the file is protected. Section 2 contains a table; section 2 is not protected when the file is protected.
When the file is protected I can use the arrow keys to move through the table in Section 2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.