Search results for query: *

Hi, Skip, That was done long ago in my macro, before all the bookmark inserts were made and before the table was even created with Set Wrd=CreateObject("Word.Application") Now, I'm in the middle of a page worth of lines under With Wrd DJC

The first thing you said, I didn't understand. If it's lacking something, it was lacking that thing as "written" by the macro recorder in Word. What's this oWordAppl bit? Do you recommend substituting that one line for both my lines, then? I tried adding "ActiveDocument." between "Selection."...

Hi, Just checked to make sure. Yes I do. DJC

Hi, Skip, My experience has been that what is recorded inside Word when you do something is not what works in a macro written to operate from Excel. None-the-less, I tried it, and it suggested something that seemed like it might work. This is what I added to the Excel macro where "Goods" is the...

Hello, I have written(with help from this discussion group) a macro in Excel which directs the opening of a Word template document and the placement of a variety of information from an Excel workbook at bookmarks in that document. At one of those bookmarks, a table is created, placed, and its...

Thanks, Caution, Your examples really did help. Here’s what I did to get my Excel workbook putting info into the bookmarks of a Word document. First, a bit of Diming of Excel data as strings, s2 being one of these Set Wrd = CreateObject("Word.Application") Const wdGoToBookmark As Long = -1...

Thanks, CMP, I will study these and report back how I do. Donna

Skip, Varies, a lot. I'd say up to 10. And different text on each page, only with parts that have to match exactly. Donna

Hi Skip, Maybe it's because it's the end of the day here in the UK that I'm not understanding this. Are you saying that I can create something in Excel that has all the Word Document type bits like the header and the logo and the the footer and the text that is going to be the same for each and...

Skip, The end result that my boss wants is a Word document. The reson for getting Excel involved is that pieces of the document need to match dot for dot in order for the shipment not to end up held by Homeland Security with huge storage charges put on it while you track down the stray comma...

Skip, I meant that I need to creat the table in the Word document from the Excel macro. Caution MP, I didn't do that because I didn't know how to record a macro for the creation of a tabe that would vary as to the number of rows. I don't want to ask the user how many rows, since that...

I'm writing a VBA macro from Excel. The user supplies the information for an invoice by responding to Userforms in the Excel environment. The macro takes the input information, adds tied information (addresses tied to recipient names, product descriptions and prices tied to product numbers...