LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Determining build date of an Add-in

Please excuse the reposting. When I posted it before I had a
misspelling in the subject,
perhaps explaining the lack of response.

I would like a Help|About command on the menu created when my Add-in
is loaded.
In it I'd like to report a Version number and the timestamp for when I
last modified the
add-in. Here's what I have written:

Set wkbWkb = ThisWorkbook
strFileName = wkbWkb.Name
Set wksWks = wkbWkb.Worksheets("UserData")

strPath = wkbWkb.Path & "\" & strFileName
varDate = FileDateTime(strPath)

iCol = GetColIndex2(wksWks, "VERSION")
strVersion = wksWks.Cells(2, iCol)
strMsg = "JOC Membership Macro Package Version " & strVersion & "
Last modified " & varDate
MsgBox strMsg

As you can see, I get teh Version number out of cell stored in a
worksheet belonging to the add-in workbook.
That works fine.

What doesn't work is the way I attempt to get the "build date." I
would think that varDate would be reported
as the timestamp I see in Windows Explorer, i.e., the date I last
modified the .xla file. Instead, I get
a time stamp that seems to be the time the add-in is loaded.

Why does it behave this way? How can I get it to report the actual
last-modified date/time?

TIA

Ed



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining a future date, again Andrew Taylor[_2_] Excel Discussion (Misc queries) 3 November 19th 08 06:37 PM
Determining an annual review date from an employee start date Phrank Excel Worksheet Functions 3 November 29th 07 06:37 AM
Formula for determining if two date columns fall within specific date range Igottabeme Excel Worksheet Functions 2 April 21st 06 02:50 AM
Formula for determining if two date columns fall within specific date range Igottabeme Excel Discussion (Misc queries) 1 April 20th 06 10:03 PM
Determining a Date Mark Excel Discussion (Misc queries) 1 July 1st 05 03:13 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"