word 2013

  1. E

    Excel to Word, "FileLocked" with 2 open Word documents - error

    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...
  2. MrDB4Excel

    Link Data From Excel to Word Without Using Tables

    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...
  3. A

    Error when adding table to Word from Excel VBA

    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...
  4. E

    Problem with export table - find/replace a text inside a table in word through excel vba code

    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...
  5. B

    VBA: change orientation to Landscape for word document converted from excel

    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...
  6. MacroAlan

    Paste Excel chart into Word using VBA

    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...
  7. M

    Use VBA to integrate Excel data into Word document through VLookup function

    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...
  8. W

    Word Macro to Copy Cells from Excel

    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...
  9. A

    VBA to update Word Docs Title and Author in a folder

    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...
  10. R

    Find & Replace using Macro in Word

    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...
  11. H

    Is it possible to connect Word and Excel?

    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...
  12. T

    Replacing text on Word document from excel macro

    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...
  13. V

    Microsoft Office 2013 home , probelm with mail merge and labels using excel and word

    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...
  14. caringsharingbristolbilly

    Word 2013 - cursor doesn't move when pressing space bar

    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...
  15. E

    Pasting Large Text

    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...
  16. V

    VBA How to Exclude Words from Macro

    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...
  17. S

    Call FillBookmark with image VBA Access --> Word

    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...
  18. S

    Fill a ComboBox from a Database

    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...
  19. M

    Character Codes

    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...
  20. G

    Form Referencing excel spreadsheet from word

    This is more of a Microsoft word question since I'm actually pulling data from excel rather than pushing it. Excel 2013 Table is a template to calculate those values. 1. Update the excel template 2. Click update the first line on word 3. Save excel template as different name 4. Repeat but...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top