ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA - Entries Into Properties (https://www.excelbanter.com/excel-programming/338427-vba-entries-into-properties.html)

ajocius[_26_]

VBA - Entries Into Properties
 

Group,
Is there a way to enter data into the Excel Properties page. I'd
like to put a company name, change the author etc. I'd also like to do
this using VBA. When I do a simple macro and enter data, returning to
the property page on edit, nothing I entered is shown. What am I doing
wrong? Thank you in advance for your assistance.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=399436


Tom Ogilvy

VBA - Entries Into Properties
 
Just a guess on what you are talking about, but:
Are you using the BuiltInDocumentProperties entries?

These are workbook level entries.
--
Regards,
Tom Ogilvy

"ajocius" wrote in
message ...

Group,
Is there a way to enter data into the Excel Properties page. I'd
like to put a company name, change the author etc. I'd also like to do
this using VBA. When I do a simple macro and enter data, returning to
the property page on edit, nothing I entered is shown. What am I doing
wrong? Thank you in advance for your assistance.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:

http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=399436




ajocius[_27_]

VBA - Entries Into Properties
 

Yes, how do I fill those fields.

Ton

--
ajociu
-----------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...fo&userid=1769
View this thread: http://www.excelforum.com/showthread.php?threadid=39943



All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com