word object

  1. H

    Open Excel Workbook from Word and kill Word VBA process

    Hi! I have an interesting nut to crack. I am making a Word install program for Excel. The install program executes from Word, checks if the updated font-file is installed (normal.dotm) and opens Excel (Workbooks.Open) if the lastest font-file is not installed. On the install program in Excel...
  2. P

    Creating a custom editor for Domain specific Language

    Hi I have created an editor i.e, a cell or a text box, in which text can be entered manually or from dropdown lists present in the same sheet. If a keyword is inputted manually, it is validated that it must belong to the values in dropdown lists. What i need is There should be a separate...
  3. A

    VBA Modify Text in Embeded Word Document through Excel Macro

    Hi, I have an embedded word document that I want to have references to the cells in the worksheet. How can I write VBA code that updates the text values in the embed document using the cell value. Or references the cell value in the embed document. If this is no clear, I want to have cell...
  4. I

    Automation Error -- I Need a Guru!

    I'm having trouble creating a report, in Word, from Excel. Every other time I try to execute the macro, I get an error 426. I did a search and found someone else with the same problem: http://www.mrexcel.com/forum/showthread.php?t=124028&highlight=remote+server+machine And his problem was...
  5. T

    Check the Word box in references via code?

    Hey all! I'm writing a macro which will be shared by other users who most-likely won't have references to MS Word enabled (the box checked in Tools->References). Is there a code I can put in there that would activate this, if necessary? Thanks!
  6. A

    Copy word drawing into excel

    I created a timeline made up of different shapes & text in Word. I've grouped them into one 'picture' which I would like to copy into Excel. What I'm trying to achieve is to have a picture of the timeline above data entered in the spreadsheet below. When I copy paste or import Microsoft...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...