Browse by Tags

2003
2007
access
asp.net
Automate Mail Merge
C#
find
loop
macro
Mail Merge
Office
office 2003
Office 2007
replace
VBA: select WHOLE document (i.e. the not the current textbox!)
vsto
XP/2003

VBA: select WHOLE document (i.e. the not the current textbox!)

I am using the following code to try to copy the current document to a new document (for further processing): Selection.WholeStory Selection.Copy Documents.Add Template:="Normal", NewTemplate:=False, DocumentType:=0 Selection.PasteAndFormat (wdPasteDefault) ActiveDocument.SaveAs FileName:=sTemp...

Posted to Word (Forum) by microsoft on 03-24-2010
Search and replace text containing superscripts in Word

Hi, I have many documents in Microsfot Word 2007 (RTF, DOC or DOCX) which the text includes superscripts. One of the issues I need to solve is to find and replace sentences in which a superscript is located after the stop (the dot), adding a carriage return after the superscripts. The sentences look...

Posted to Word (Forum) by microsoft on 01-18-2010
open microsoft access form from a button in a word document

i need to open a microsoft office access 2003 form from a button created with vba code in microsoft word document so basically click on button in word and it opens access and then displays the relevant form i tried application.followhyperlink "c:\assignment\HiStyle Kitchen.mde" but didnt work...

Posted to Access Forms (Forum) by microsoft on 09-14-2009
From Access 2007, Open Word Application then using Application.Quit. Getting Automation Error: The object invoked has disconnected from its clients

From my Access application, using vba, I can successfully open Word, select a template, add text to bookmarks and save and close the document. The code for this is attached (minus all the filling in the bookmarks stuff) But I can't seem to actually quit the instance of Word that I created. I need...

Posted to Access (Forum) by microsoft on 07-08-2009
Problem: How can I add in excel vba a range.name to formula1 of a validationlist if range inludes more lines

Please I need help in excel vba with validationlist of dropdowns I use the code below. I create a range, give the range a name and put it to a validation list of a cell. This works fine as long as the range consists only of one line. If I write in my code: .Range(.Cells(1, 2), .Cells(1, 255)).Name =...

Posted to VSTO (Forum) by microsoft on 05-29-2009
Problem: How to Automate Mail Merge from ASP.NET application?

I plan to make a form in ASP.NET that will let the user select which labels he wants generated. I need to automate the following example and 30,000 other labels via Word's Mail Merge: Part Number Description Image of Barcode The description is derived from attributes of an entity in a SQL Server...

Posted to VSTO (Forum) by microsoft on 05-29-2009
Problem: Replace text in a specified style

In a document with the styles "Normal" and "Heading 1" I want to replace all text strings within "Heading 1" with text strings from an array. The code below could maybe work as a rough draft, although it does not work. With Selection.Find .ClearFormatting .Style = ActiveDocument...

Posted to Word (Forum) by microsoft on 05-28-2009

Page 1 of 1 (7 items)

Browse by Tags

VBA: select WHOLE document (i.e. the not the current textbox!)

Search and replace text containing superscripts in Word

open microsoft access form from a button in a word document

From Access 2007, Open Word Application then using Application.Quit. Getting Automation Error: The object invoked has disconnected from its clients

Problem: How can I add in excel vba a range.name to formula1 of a validationlist if range inludes more lines

Problem: How to Automate Mail Merge from ASP.NET application?

Problem: Replace text in a specified style