word doc and excel

Hi, I have search hi and low on the internet and this site but cant seem to get exactly what i am after. So hoping someone can point me in the right direction or assist. 1. Have an existing word doc which is quite busy with required information.Consists of 10 participants per enrollment sheet...

I am new to VBA and using Macros. I need to write a code that will take the following excel template and create a word document out of it. The excel file has 7 different sheets in total that I will somehow need to all pile into one single code to spit out a neater word document. The image below...

Hi all, I have a code that is replacing hyperlinks to open word documents on a networked document as everyone has a unique identifier for the initial drive on the network. For example, I am on the H drive, but the same document for a colleague is on the N drive. I've created a range in excel...

Hi! Hope someone can help with the following: The code below (with the help of Macropod - thanks again!) takes details from a single row of a worksheet (row 4) and puts them into relevant places of a Word template, then saves it. Public Sub ExportToWord() Dim WkSht As Worksheet Set WkSht =...

Hi, I would like to extract all info from excel tables into a word document verbiage by creating a macro/vba but my data is not set up consistently. There is not a consistent range as it varies daily and there are three different entity category(ABC, DEF, etc) I then copy each of the...

Hi, I am able to copy the contents of the values that is extracted from field in word documents to excel right now and i am trying to extract the contents from the word documents based on specific titles and their corresponding contents. i have tried out with the following code, with the word...

Excel Data:- <tbody> Data A Data B Data C Xya Dsa Hta Hya Jsa Rtf </tbody> Word Output:- <tbody> Data A Xya Data B Dsa Data C Hta </tbody> <tbody> Data A Hya Data B Jsa Data C Rtf </tbody> I have illustrated my question with an example. My source data is the excel...

Hi there I have the strangest problem! I have a form builder that opens a word template and populates the letter based on the values in the form, then saves the .dotx template as a .doc file. It works fine unless I go back to the form builder and make a change and request the program to run...

Hello, I'm looking for a way to export comments from MS Word and display them in Excel alongside the corresponding highlighted text, with one text/comment pair per row. I think a macro should be able to achieve this pretty easily but I'm not very good at that sort of thing. Can anyone help...

Okay, I need something extremely simple because I am a self-taught VBA macro user. I have a macro that opens 15 Excel spreadsheets one of which is for reference only and the others I may or may not alter. Then I have another macro that saves and closes each of these spreadsheets. I need to...

I have a spreadsheet and each row contains information about a specific customer. What's the easiest way to make each row and all the information in each column generate to a seprate Word document for each customer (row)? I would also like to keep the column title information visible for each...

Hi, I have a code to copy the data from excel and paste into word document through book marks. I am getting error to save the word document in specific folder with the given name in spread sheet. Sub CopyRangeToWord() Dim wd As Word.Application Dim doc As Word.Document Dim templ...

i want to select a folder which contains the excel files in sheet1 in each file, copy A1:F50 go to Master word file Paste as image size the image to certain width

Please help. I'm hopelessly lost. I've created an excel survey using command buttons and a userform, which generates a row of data. I'm attempting to impute the data into a "survey feedback" word document. My goal is to inform bar graphs in this word document, by linking the graph data to the...

Hi all you fantastic geniuses, I have a question about embedding a word object. I have a long formula (about 5-6 pages) that is populated in excel, with input in excel, which looks fine and prints (as pdf) just the way its supposed to. The problem is that at the end of this formula I need 7...

If someone has a solution to this problem, I would be very grateful!! I'm no expert in VBA, so any help you can provide would be most helpful. I have my data in Excel 2007, protected by a password to open file, and read only password. I have a form in Word 2007. The user opens the Excel...

I am using VBA to create a word document (.docx). This word document contains plain text content controls as well as picture content controls. I then use VBA to automatically select a picture based on the code below Set oCC =...

Hello I am newbie with this VBA. I am trying to merge my excel data into word all with VBA. My word and excel version is 2000 9.0.2812 Please would you help me? I really apreciate any help !!. I will explain in detail my needs. I have a big excel table with data. When I open this excel file...

Hi, I have inserted a word document in one of the cell in my worksheet. Now my requirement to to search for some string in that doc and accordingly perform some task.. so i want to know can we connect to word documents through macros?