ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Addin Modified date/time (https://www.excelbanter.com/excel-programming/344956-addin-modified-date-time.html)

Tony McGee

Addin Modified date/time
 
Hello all

I have written an Excel addin that does everything I want it to do.

I have included an about box & was wondering if the date/time last modified
property of the addin file is avaialble or accessible to use as "version
information" in the about box to save me having to manually update a value
every time I make a change?

Thanks
Tony McGee



Chip Pearson

Addin Modified date/time
 
Tony,

ThisWorkbook.BuiltinDocumentProperties("Last Save Time").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Tony McGee" wrote in message
...
Hello all

I have written an Excel addin that does everything I want it to
do.

I have included an about box & was wondering if the date/time
last modified
property of the addin file is avaialble or accessible to use as
"version
information" in the about box to save me having to manually
update a value
every time I make a change?

Thanks
Tony McGee





Tony McGee

Addin Modified date/time
 
Thanks Chip

Barely had time to click on the send button!!
Tony

"Chip Pearson" wrote in message
...
Tony,

ThisWorkbook.BuiltinDocumentProperties("Last Save Time").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Tony McGee" wrote in message
...
Hello all

I have written an Excel addin that does everything I want it to
do.

I have included an about box & was wondering if the date/time
last modified
property of the addin file is avaialble or accessible to use as
"version
information" in the about box to save me having to manually
update a value
every time I make a change?

Thanks
Tony McGee








All times are GMT +1. The time now is 11:06 AM.

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