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
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
Function CustomProperty(sProp As String) As Variant
CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
End Function
HTH
--
AP
"KC" <[email protected].(donotspam)> a écrit dans le message de news:
[email protected]...
> 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" <[email protected].(donotspam)> a écrit dans le message de news:
[email protected]...
> 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" <[email protected].(donotspam)> a écrit dans le message de news:
[email protected]...
> 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" <[email protected].(donotspam)> a écrit dans le message de news:
> [email protected]...
> > 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" <[email protected].(donotspam)> a écrit dans le message de news:
[email protected]...
> 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" <[email protected].(donotspam)> a écrit dans le message de news:
>> [email protected]...
>> > 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" <[email protected]> wrote in message
news:[email protected]...
> Try:
>
> Function CustomProperty(sProp As String) As Variant
> Application.Volatile
> CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
> End Function
>
>
> HTH
> --
> AP
>
> "KC" <[email protected].(donotspam)> a écrit dans le message de news:
> [email protected]...
> > 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" <[email protected].(donotspam)> a écrit dans le message de news:
> >> [email protected]...
> >> > 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
> >>
> >>
> >>
>
>
no luck, i've tried to save the and re-open the file, still i don't see the
updated "file property" value getting refreshed, i would have to revisit the
cell and refresh it manually
Let me try to explain once again what i'm really searching for!
* there are many places in Excel sheets where i user many common fields
(client/author/filepath/release version/base version/baselined date/ect), now
all i'm trying to achive is to store all these common things into custom/file
properties, just like i do in MSWord, and go on referencing this custom/file
properties.
now with your approach i'm able to retrive my own defined custom properties,
but if i make any changes to these fields, this value is not getting
reflected no matter what i do, unless i revisit the cell and manually refresh
it!
hope you know what i'm trying to achive here.
Thanks again,
-KC
"Bob Phillips" wrote:
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > Try:
> >
> > Function CustomProperty(sProp As String) As Variant
> > Application.Volatile
> > CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
> > End Function
> >
> >
> > HTH
> > --
> > AP
> >
> > "KC" <[email protected].(donotspam)> a écrit dans le message de news:
> > [email protected]...
> > > 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" <[email protected].(donotspam)> a écrit dans le message de news:
> > >> [email protected]...
> > >> > 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
> > >>
> > >>
> > >>
> >
> >
>
>
>
Hello guys,
I found the answer for my other part of my question.
I'll will also need to make sure the spreadsheet is updated manually. To do
this-
Click on <Tools><Options><Calculations><Manual>
OR <F9>
Thanks again.
-KC
"KC" wrote:
> no luck, i've tried to save the and re-open the file, still i don't see the
> updated "file property" value getting refreshed, i would have to revisit the
> cell and refresh it manually
>
> Let me try to explain once again what i'm really searching for!
>
> * there are many places in Excel sheets where i user many common fields
> (client/author/filepath/release version/base version/baselined date/ect), now
> all i'm trying to achive is to store all these common things into custom/file
> properties, just like i do in MSWord, and go on referencing this custom/file
> properties.
>
> now with your approach i'm able to retrive my own defined custom properties,
> but if i make any changes to these fields, this value is not getting
> reflected no matter what i do, unless i revisit the cell and manually refresh
> it!
>
> hope you know what i'm trying to achive here.
>
> Thanks again,
> -KC
>
> "Bob Phillips" wrote:
>
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > Try:
> > >
> > > Function CustomProperty(sProp As String) As Variant
> > > Application.Volatile
> > > CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
> > > End Function
> > >
> > >
> > > HTH
> > > --
> > > AP
> > >
> > > "KC" <[email protected].(donotspam)> a écrit dans le message de news:
> > > [email protected]...
> > > > 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" <[email protected].(donotspam)> a écrit dans le message de news:
> > > >> [email protected]...
> > > >> > 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
> > > >>
> > > >>
> > > >>
> > >
> > >
> >
> >
> >
Didn't I say that - 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)
"KC" <[email protected].(donotspam)> wrote in message
news:[email protected]...
> Hello guys,
> I found the answer for my other part of my question.
>
> I'll will also need to make sure the spreadsheet is updated manually. To
do
> this-
> Click on <Tools><Options><Calculations><Manual>
> OR <F9>
>
> Thanks again.
> -KC
>
>
> "KC" wrote:
>
> > no luck, i've tried to save the and re-open the file, still i don't see
the
> > updated "file property" value getting refreshed, i would have to revisit
the
> > cell and refresh it manually
> >
> > Let me try to explain once again what i'm really searching for!
> >
> > * there are many places in Excel sheets where i user many common fields
> > (client/author/filepath/release version/base version/baselined
date/ect), now
> > all i'm trying to achive is to store all these common things into
custom/file
> > properties, just like i do in MSWord, and go on referencing this
custom/file
> > properties.
> >
> > now with your approach i'm able to retrive my own defined custom
properties,
> > but if i make any changes to these fields, this value is not getting
> > reflected no matter what i do, unless i revisit the cell and manually
refresh
> > it!
> >
> > hope you know what i'm trying to achive here.
> >
> > Thanks again,
> > -KC
> >
> > "Bob Phillips" wrote:
> >
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Try:
> > > >
> > > > Function CustomProperty(sProp As String) As Variant
> > > > Application.Volatile
> > > > CustomProperty = ActiveWorkbook.CustomDocumentProperties(sProp)
> > > > End Function
> > > >
> > > >
> > > > HTH
> > > > --
> > > > AP
> > > >
> > > > "KC" <[email protected].(donotspam)> a écrit dans le message de
news:
> > > > [email protected]...
> > > > > 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" <[email protected].(donotspam)> a écrit dans le message de
news:
> > > > >> [email protected]...
> > > > >> > 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
> > > > >>
> > > > >>
> > > > >>
> > > >
> > > >
> > >
> > >
> > >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks