#1
|
|||
|
|||
Open word userform from excel
I want the button on userformTombol in document "Agendaku.docm" activate after The Excel application Quit.
What is the mistakes in the following code: ? (error message : Object dosn't support this property or method) Code:
Private Sub CommandButton1_Click()Dim ObjWord As Object Dim ObjDoc As Object Dim ObjForm As Object Set ObjWord = GetObject(, "Word.Application") Set ObjDoc = ObjWord.Documents("D:\Agendaku.docm") ObjWord.Visible = True Set ObjForm = ObjWord.ObjDoc.UserFormTombol ObjForm.CommandButton1.Enabled = True ObjForm.CommandButton3.Enabled = False ActiveWorkbook.Save Windows.Application.Quit End Sub |
#2
|
||||
|
||||
Cross-posted at: https://www.mrexcel.com/forum/genera...orm-excel.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
You are using GetObject which means Word must already be running. If it isn't then you need to use CreateObject.
Assuming that works, then Agendaku.docm must already be open. If it isn't then that will fail too.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#4
|
|||
|
|||
Quote:
Agendaku.docm is already open. But why does the error message still appear ? |
#5
|
||||
|
||||
You haven't told us which line is failing.
Assuming the Agendaku.docm file does indeed contain a userform with the name UserFormTombol, I would have expected you would need to LOAD that userform before trying to set the enabled values of controls in it. I also don't know if those two controls exist on your userform.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word VBA: Open and work with a different doc from userform? | AlanC | Word VBA | 2 | 06-25-2018 06:58 AM |
Word UserForm search in Excel | jhancock1994 | Word VBA | 3 | 05-21-2017 11:51 PM |
Excel Userform to Word Template Bookmarks | JCrinage | Excel Programming | 1 | 11-02-2016 07:03 PM |
Populate Combobox from Excel into a Word UserForm | ferguson4848 | Word VBA | 3 | 10-28-2016 09:05 PM |
Trying to populate Word bookmarks with excel UserForm | smd1112 | Excel Programming | 7 | 09-03-2014 09:42 PM |