| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File/custom Property fields
Hi There,
Now I know how to create these File/Custom property fields, but I don't know how to make you of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File/custom Property fields
sorry there was a typo,
Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make *use of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC "KC" wrote: Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make you of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File/custom Property fields
Paste the Function I sent you into a standard Module.
In your worksheet, enter: =CustomProperty("blah") HTH -- AP "KC" .(donotspam) a écrit dans le message de news: ... sorry there was a typo, Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make *use of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC "KC" wrote: Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make you of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File/custom Property fields
Thanks Ardus, it works, but now i have another problem; if i make any changes
to the file properties the changes are not getting refreshed in the cells! thanks, -KC "Ardus Petus" wrote: Paste the Function I sent you into a standard Module. In your worksheet, enter: =CustomProperty("blah") HTH -- AP "KC" .(donotspam) a écrit dans le message de news: ... sorry there was a typo, Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make *use of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC "KC" wrote: Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make you of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File/custom Property fields
Be aware that that will still require forcing a calculation for the cell to
update. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ardus Petus" wrote in message ... Try: Function CustomProperty(sProp As String) As Variant Application.Volatile CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp) End Function HTH -- AP "KC" .(donotspam) a écrit dans le message de news: ... Thanks Ardus, it works, but now i have another problem; if i make any changes to the file properties the changes are not getting refreshed in the cells! thanks, -KC "Ardus Petus" wrote: Paste the Function I sent you into a standard Module. In your worksheet, enter: =CustomProperty("blah") HTH -- AP "KC" .(donotspam) a écrit dans le message de news: ... sorry there was a typo, Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make *use of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC "KC" wrote: Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make you of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File/custom Property fields
Function CustomProperty(sProp As String) As Variant
CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp) End Function HTH -- AP "KC" .(donotspam) a écrit dans le message de news: ... Hi There, Now I know how to create these File/Custom property fields, but I don't know how to make you of them in the worksheet! in simple, How to insert the File/custom property fields into excel cells? Thanks, -KC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to cycle through each of property and its value of Class? | Excel Worksheet Functions | |||
| Property Let: assign return value of Double when passing String | Excel Discussion (Misc queries) | |||
| Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
