Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining a future date, again | Excel Discussion (Misc queries) | |||
Determining an annual review date from an employee start date | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Determining a Date | Excel Discussion (Misc queries) |