Macro to change file properties

T

TomH

I am trying to create a macro that will insert a block of text into the
"comments" field in the file properties.

in word this is done by the following block
With Dialogs(wdDialogFileSummaryInfo)
.Comments = " some text "
.Execute
End With

how can I do this in excel
 
P

Peter T

wb.Comments = "Hello"

where wb refers to a workbook, eg ThisWorkbook, ActiveWorkbook,
Workbooks("Book1.xls")

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA script on document open or close 8
link comments section of properties dialog box to footer in Excel 6
Help with Macro 3
Macro that will insert a simple text string in top cell of text file 1
How do I add properties to add-in ? 5
Changing File "Summary" Properties Programmatically 15
Advice on multiple macros, same code just a different column 9
Macro for Creating Word Document!! 5

Top