Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Saving work documnet property in excel
when i comment this line it doesn'tgive me any error output = output + Prop.Name + " = " + Str(Prop.Value) + vbCrLf so there is proba something worng i am doing here- 12jan87
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Saving work documnet property in excel
ok i got this far now Sub DocumentProperties() Dim output As String Dim Prop As DocumentProperty Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Dim i As Integer Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set xlWB = xlApp.Workbooks.Add...- 12jan87
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Saving work documnet property in excel
Here is the code that I have so far to show word document property in a message box Sub DocumentProperties() Dim Output As String Dim Prop As DocumentProperty For Each Prop In ActiveDocument.BuiltInDocumentProperties Output = Output + Prop.Name + " = " + Str(Prop.Value) + vbCrLf Next MsgBox...- 12jan87
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
