word macro

  1. 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...
  2. R

    Excel macro to call Word macro stopped working

    I would appreciate any insight as to why the following two previously working (as of December 2016) macros might now give me error #16 (from MS Word). I am using MS Office Plus Professional 2010. ============Excel Macro:=========== Option Explicit Private Sub Worksheet_BeforeDoubleClick _...
  3. T

    Macro to copy table from excel to word

    I am using the below code in MS Word to copy a table from excel file to word file. .................................. Private Sub Document_Open() Set wdapp = GetObject(, "Word.Application") Dim tbl As Excel.Range Dim wordoc As Word.Document Dim xlApp As Object Dim xlWB As Object Dim...
  4. S

    VBA macro to rename a word file

    I have a file saved with a name. EX: Create Project Related Purchase Order, I need to change the name (as Create_Project_Related_Purchase_Order_QRG) with underscores after every word in the file name and _QRG at the end of the file. I want to use the VBA code to do this automatically in a...
  5. S

    File Save as and pasting from clipboard in VBA macro

    Hi I have the following code which is pasting the same hard coded value every time (Test File.doc) instead of pasting from clipboard, Please help me change the code to pate from clipboard while renaming the file using save as. ChangeFileOpenDirectory "C:\Documents and...
  6. Dimmthewitted

    Word Macro for find all / select entire page / cut to new document

    Hello, I am working on a VB script to scan a large document of company statements for certain criteria and then pull each page out and paste it in a new document. I am not a VB coder and got in a bit over my head with deadlines looming. Right now the code copies and pastes a page into a new...
  7. D

    GetObject Trouble

    I am interested in pulling values from Excel into Word to automate reports. I have in the past used the GetObject function successfully and really liked the functionality. Recently our company upgraded to Office 2007 and when this happened I have not been able to get the same macros to work...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top