Recent content by ACH381

Additional Information: This is an Office 2007 (probably ribbon) issue. Using all the options already suggested in previous threads work in Office 2000, wrapping the text as expected, but when opened in Office 2007 and Office 2010 the line feed character is ignored. So if anyone has an idea...

PHV: Thanks for the quick response but neither of those work either. I've done this several years ago but I'm having a mental block. I'll keep searching.

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 =...

Thanks I'll give it a try and let you know how it works. I'd like to be able to walk through the report using something like Find Next to let the user find each instance of the word or phrase and replace only what he wants to and not replace everything automatically.

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...

OK. We'll just have to keep looking. Thanks

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...