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

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

Paste the Function I sent you into a standard Module.
In your worksheet, enter:
=CustomProperty("blah")

HTH
--
AP

"KC" <someone@example.com.(donotspam)> a écrit dans le message de news:
FD36B6E0-D2D3-47AB-AE11-7FADCDBDDCAA@microsoft.com...
> 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

Paste the Function I sent you into a standard Module.
In your worksheet, enter:
=CustomProperty("blah")

HTH
--
AP

"KC" <someone@example.com.(donotspam)> a écrit dans le message de news:
FD36B6E0-D2D3-47AB-AE11-7FADCDBDDCAA@microsoft.com...
> 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

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" <someone@example.com.(donotspam)> a écrit dans le message de news:
> FD36B6E0-D2D3-47AB-AE11-7FADCDBDDCAA@microsoft.com...
> > 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
>
>
>

Try:

Function CustomProperty(sProp As String) As Variant
Application.Volatile
CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
End Function


HTH
--
AP

"KC" <someone@example.com.(donotspam)> a écrit dans le message de news:
FD0328AC-120E-45BC-A002-A61C375628A2@microsoft.com...
> 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" <someone@example.com.(donotspam)> a écrit dans le message de news:
>> FD36B6E0-D2D3-47AB-AE11-7FADCDBDDCAA@microsoft.com...
>> > 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
>>
>>
>>

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" <ardus.petus@laposte.net> wrote in message
news:uNeOkYypGHA.4216@TK2MSFTNGP04.phx.gbl...
> Try:
>
> Function CustomProperty(sProp As String) As Variant
> Application.Volatile
> CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
> End Function
>
>
> HTH
> --
> AP
>
> "KC" <someone@example.com.(donotspam)> a écrit dans le message de news:
> FD0328AC-120E-45BC-A002-A61C375628A2@microsoft.com...
> > 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" <someone@example.com.(donotspam)> a écrit dans le message de news:
> >> FD36B6E0-D2D3-47AB-AE11-7FADCDBDDCAA@microsoft.com...
> >> > 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
> >>
> >>
> >>
>
>

Function CustomProperty(sProp As String) As Variant
CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
End Function

HTH
--
AP

"KC" <someone@example.com.(donotspam)> a écrit dans le message de news:
508DE4E4-54FB-48B3-A3A7-CE201E7AB569@microsoft.com...
> 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