word 2013

I'm trying to populate a Word document with info from a spreadsheet. I created Merge fields in the Word doc, e.g. <<Patient_Name>>. The excel book I'm testing with has two tabs, one called Sheet1 that has a row with the field names and a row with the values, the other sheet just has a button I...

Hi all, I've been looking for a solution to my problem for way too long so I hope someone here can help. From an Excel workbook, I run a macro that will open/activate an existing Word doc, copy some info from the spreadsheet onto this word doc, then, if the user requires it, another existing...

I have an Excel workbook and an MS Word document that contain email correspondence content. The Word document contains information that is present in 3 basic lines as follows: The first line contains an expression that includes a link code, a sent date, and a received time. This will be apparent...

Hello, I recently was able to fix my code by adding a table to Word From Excel with VBA However now if I want to add 2 or more tables then it gives me the Error " Run Time Error 462: The remote server machine does not exist when working with WORD via Excel VBA " I am not sure how to fix this...

Hello y'all! I'm smacking my head down with something I'm pretty sure that's simple, but I couldn't find any proper solution for it I made a code that succesfully paste an excel table to word, this table has four strings with differents text formats an each cell, after pasting I'd like to...

Dear all, I have an excel file which I want to convert to word. As the column number is big, the word document doesn't show all information, some of columns are not visible. I changed manually the orientation to Landscape and I was able to see all data. Issue VBA the change orientation to...

It seemed like it should be so easy. I'm creating a bunch of data from Access and sending to Excel and then creating a bunch of Charts. Charts look good. As each is created, I want to copy it and paste into a Word document. Set WDapp = CreateObject("Word.Application") WDapp.Documents.Open...

Hello, I am trying to pull data from multiple Excel 2013 workbooks into a Word 2013 document that I cannot simply copy and paste a link from Excel into Word. I tried researching this on other articles and threads, but they seem to only include portions of what I am looking to accomplish, so...

Hi, I have been Googling for quite a while now, and doing that, I have seen that most macros where written and used by Excel. I want to do a macro in word that will open a specific sheet in the excel workbook and copy its contents to a ready-made word template . Can anyone help me in achieving...

Hi All, I'm trying to have code so that it will update Author, Title, Company etc of multiple Word Docs in a folder. I have found some code on the interwebs but it bugs out with "Compile Error. Object required " on "strStartPath" The code I found hard codes the changes in the code and it would...

Sub FindRiskWords() Dim oRng As Word.Range Dim arrExcelValues() Dim arrExcelValues1() Dim i As Long Dim x As Long Set objExcel = CreateObject("Excel.Application") Set objExcel1 = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("\\path") objExcel.Visible = False...

I have a huge number of Word documents that I would like to go through and pull certain, specific information out of and list in Excel. However, it's not worth the time to do this task by hand. Is there any way I could automate this process somehow? The Word documents are specifications that...

Hello, I have a lot of word documents that need to be constantly updated. The most important thing that needs to be changed is the dates on the documents. Each word document has multiple pages, and each page has a date in the format MM/DD/YEAR on the top right hand, no headers. Also on the...

Hello, I found your site today while googling for a problem I have. Today I purchased Microsoft Office 2013 as i need to make a few thousand labels. So first I opend excel and in column 1 I added data "RS43567000" and dragged it down to row 3000 giving me 3000 different codes. I save it as...

Hi all. Just had Word 2013 installed at work, and the cursor behaviour is driving me mad. When I press space having just finished a word, the cursor stays put, firmly attached to the end of the word I've just typed. So, If I type the word 'cucumber' and hit space, the cursor stays here...

Hi, I would like to paste a Word doc (apprx 2 pages) into ONE CELL in Excel. It's a lot of text, but I'm wondering if I can paste it into one cell on Excel, and keep the cell size small/standard size? I've tried the shrink to fit but it doesn't work with this much text. And I don't want to...

This macro is actually in Word, but the functions shouldn't be too different. What I want to do is to highlight all words ending in -ing but excluding some words like bing (as in the cherry), thing, and being. I figured out how to get the macro to skip over 3 and 4 letter words, but I am not...

Dear all, Below codes fill the bookmarks in Word, no problem there. However, I'd like to add the logo of client companies to this, but I do not know how to call up images with FillBookmark based on the selected Contact. The images are saved in the folder \logos which is in the same folder as...

Dear all, I am linking my Access Database to a UserForm in Word and have written below code. When I test the macro there are no errors, but the ComboBox is empty. Can anyone tell me what I'm doing wrong here? Private Sub UserForm1_Initialize() On Error GoTo UserForm1_Initialize_Err...

This is probably a really simple answer. I have a homework assignment for a Microsoft Office class, and it is requiring me to make the * with the character code 002A. I learned how to make character codes by pressing alt + (some number), but never with any letters. Please let me know how I can...