Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 132 different files that need to have the same text: "FORWARDED
TO PM DD-MM-YYYY" in the comment section in each of the file's property box. I tried to record a macro, but nothing happens in the property comment box. As I enter the information in each file, I have been opening the property box and been cutting and pasting this information, but I was wondering if a macro or VBA code could be written to make it faster and easier and I wouldn't have to open all the property boxes. Can anyone write the macro or code for me? I am a novice, but know how to use the modules. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Button / Shortcut to extranal file's macro? | Excel Discussion (Misc queries) | |||
Is there a way to enter a comment on a locked cell in Excel? | Excel Worksheet Functions | |||
how to default WritePassword under excel workbook property for any files as long as those files are the offsprings of the parent file | Excel Programming | |||
FORMAT COMMENT TEXT WITH MACRO | Excel Programming | |||
Prompted to convert the file's text encoding... | Excel Discussion (Misc queries) |