So I added that as code to the first button, first right at the top, then in the middle, then very last, but no matter where I put it (if that matters at all) I'm getting a Run Time Error 424 Object Required whenever I click button 2, and the error will be on the line (If ("etermeom1") = True Then), so basically the first time the code attempts to call wddoc. And I gather that your suggested code (Public wddoc As Object) is supposed to make wddoc be recognized even on separate command buttons. So I gather what's happening is that wddoc is no longer an object by the time I click button 2. So again, for the second command button, how would I code it so that it looks for an already opened Target in the worksheet event code represents the cell that was changed. Firstly, the debugger is now catching the erase bookmark section of the code, that has always worked previously and flagging it yellow, and secondly I'm not sure if its even trying to run the code in the now already opened LegUINST.docx document. To run the VBA Macro click the Macros button to open the Macros window. At this point, with the above permutation, I dim wddoc as object and I then I set wddoc as Get Word Application, but to odd behavior. I'm running into all kinds of trouble with the second command button, though. So the first command button opens LegUINST.docx, and replaces all instances of correctly with whatever value I type in Excel. Set wddoc = GetObject(, "Word.Application") 'Replace Plan Administrator with Cell Value Then, copy-paste the below code into the VBE Editor window. Use Alt + F11 to open the VBE Editor window and insert a new module in it. Set wddoc = (ThisWorkbook.Path & "\leguinst.docx") 1 VBA Code to Hide all sheets except active worksheets Open the Workbook in which you want to hide all the worksheets except for the active sheet in Excel.
Set wdapp = CreateObject("Word.application") Capitalplantype = UCase(Range("D9").Value)
0 kommentar(er)
