excel & word

Hi all, I am trying to create a word document with inputs from Excel. Everything has been working well until I tried to create a bulleted list. The relevant portion of my code is posted below: Set wdApp = New Word.Application With wdApp .Visible = True .Activate...

Hello all, So I have a working vba code that takes a bunch of cell values in excel and places them in a specific word document I created. These values are being placed where I put bookmarks in the word document. My problem is, about 30-40% of the time I try to run the code, it freezes up and...

I have data set that contains ID numbers on Column A that repeat multiple times and vary from ID # to ID #. For example ID # 123 may take up 17 rows, while ID # 456 may take up 5 rows. To add complexity, within each ID #'s rows, there are two types of data they can fall under (i.e. ID # 123...

hey sir i need your help i want to mix multiple paragraphs into one paragraph in a cell. the final output should be one article or paragraph in a cell. for example : <tbody> A B C a b c abc d e f def </tbody> i guess you understood the thing i want to remove all my carriage returns or...

Dear all, I'm trying to extract data from Word to Excel. The data is contained in tables and subtables within these tables. The main tables are divided into "sections". In these sections I need to extract the "chapter" and "title" given that the section has a subtable. The "chapter" and...

I use an Excel format for my field staff to enter information (assessments, investigations, etc.) Through a complex combination of macros, formulas, and vlookups, I have the form set up to populate data based on a location and/or employee ID number This seems to be working well for everyone...

hi all , i currently have a macro which extracts all tables from a word to excel , but what i need is to get the header paste in first row and the copy all the tables under that section.also each header and its table should be pasted in separate sheet. Option Explicit Sub ImportWordTable()...

Hello, Before I get too deep into what I am trying to do, I need to know if this is even feasible. Is there a way to have information that is entered into excel automatically populate in a word document? Specifically text. For example, if I am answering a question in excel, the Question is...