Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Course Of The Month
9 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Accessing Word Document Properties
Posted on 2001-09-07
I have a form that opens Word documents within a web browswer control.
Having a reference to the Word Object Library, I can open the Properties dialog by using:
"mDoc.Application.Dialogs(
My question is can the data in this dialog be accessed via vb code so that I can update it with data from an Access db, without the user seeing it?
Having a reference to the Word Object Library, I can open the Properties dialog by using:
"mDoc.Application.Dialogs(
My question is can the data in this dialog be accessed via vb code so that I can update it with data from an Access db, without the user seeing it?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
- +1
9 Comments
First get a reference to Word:
On Error Resume Next
Set oWord = GetObject("", "Word.Application")
If Err.Number <> 0 Then
MsgBox "error getting word"
Exit Sub
End If
Then retreive or set the prop's like this:
Sub SetSummaryInfo ()
Dim dp As Object
Dim sTitle As String
If oWord.Documents.Count > 0 Then
Set dp = oWord.Dialogs(wdDialogFile
' Retrieve value of "Title" into a variable.
sTitle = dp.Title
' Set "Title" to a new value.
dp.Title = "My Title"
' Set the value without showing the dialog.
dp.Execute
' Save the changes
oWord.ActiveDocument.Save
End If
End Sub
Set oWord = Nothing
D'Mzzl!
RoverM
On Error Resume Next
Set oWord = GetObject("", "Word.Application")
If Err.Number <> 0 Then
MsgBox "error getting word"
Exit Sub
End If
Then retreive or set the prop's like this:
Sub SetSummaryInfo ()
Dim dp As Object
Dim sTitle As String
If oWord.Documents.Count > 0 Then
Set dp = oWord.Dialogs(wdDialogFile
' Retrieve value of "Title" into a variable.
sTitle = dp.Title
' Set "Title" to a new value.
dp.Title = "My Title"
' Set the value without showing the dialog.
dp.Execute
' Save the changes
oWord.ActiveDocument.Save
End If
End Sub
Set oWord = Nothing
D'Mzzl!
RoverM
OK - that works.
Now, can I refer to the Word Properties dialog box without opening the document in by broswer control, or does the document have to be open?
Now, can I refer to the Word Properties dialog box without opening the document in by broswer control, or does the document have to be open?
No, you cannot access the 'document' properties without a document.
So you still need to open it. If you don't want to show it, just set the oWord.Visible property to false.
D'Mzzl!
RoverM
So you still need to open it. If you don't want to show it, just set the oWord.Visible property to false.
D'Mzzl!
RoverM
When I try to run, I get an error on the GetObject function:
Runtime Error '432'
File name or class name not found during Automation operation.
The file exists and I have the correct path specified to the file.
Runtime Error '432'
File name or class name not found during Automation operation.
The file exists and I have the correct path specified to the file.
Actually, I got it to work. I was intializing my variable incorrectly.
However, I have another question related to this. I am looking to secure my Word documents by placing a password on them.
How can I go about this through vb code?
However, I have another question related to this. I am looking to secure my Word documents by placing a password on them.
How can I go about this through vb code?
This example will allow you to set a password:
With oWord.ActiveDocument
.ReadOnlyRecommended = False
.Password = "myopenpassword"
.WritePassword = "myeditpassword"
End With
To remove the password from the document, just set the password to an empty string : "".
After changing it:
oWord.ActiveDocument.Saved
oWord.ActiveDocument.Save
You have to do this because else Word 'thinks' that nothing did change, and will NOT update the password.
D'Mzzl!
RoverM
With oWord.ActiveDocument
.ReadOnlyRecommended = False
.Password = "myopenpassword"
.WritePassword = "myeditpassword"
End With
To remove the password from the document, just set the password to an empty string : "".
After changing it:
oWord.ActiveDocument.Saved
oWord.ActiveDocument.Save
You have to do this because else Word 'thinks' that nothing did change, and will NOT update the password.
D'Mzzl!
RoverM
Hi gammbro@devx,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept roverm's comment(s) as an answer.
gammbro@devx, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept roverm's comment(s) as an answer.
gammbro@devx, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
Featured Post
Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I’ve seen a number of people looking for examples of how to access web services from VB6. I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.
There is also a companion Debug Toolbar that looks like the followin…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.
This l…
- Microsoft Office
- Office 365
- Microsoft Access
- VBA
- Microsoft Excel
- Visual Basic Classic
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 4 hours left to enroll
Earn Certification
CompTIA IT Fundamentals
$49.00$44.10
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.