![]() |
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 |
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 |
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