Excel Timesheet Versions Save

:alarm_clock: This Add-In is used to produce a timesheet file with functionality to import your Google Timeline. The standard timesheet has options for start and end dates, day of week and default start, end and break times. The Google timeline options are start and end dates, UTC selection, daylight savings time parameters and title filter for timeline entries. There is also a right click shortcut to open your Google timeline to the date of the row that is currently selected. The only version is currently in VBA/XML ribbon.

2.0.0.8

5 years ago

Updated the error message logic

2.0.0.7

5 years ago

Applied some suggestions from code review post.

https://codereview.stackexchange.com/q/206017/158032

  • use constants for both module and procedure names
  • declare FreeFile as Integer
  • use ISO format yyyymmddThhnnss for log file
  • remove usage of Is in Select Case expression for error trap
  • update Case Is <> 0 to Case Else for error trap

2.0.0.6

5 years ago

Add files via upload

2.0.0.5

5 years ago
  • Added button for "Filter Title" value update

2.0.0.4

5 years ago

Minor fixes

2.0.0.3

5 years ago
  • Fixed the daylight savings settings using row date as a base for the year.
  • Added day options for timeline import.
  • Added toggle button for timeline title filter.

2.0.0.2

5 years ago

Added option for daylight savings time

2.0.0.1

5 years ago

Cleaned up module and procedure names

2.0.0.0

5 years ago

Updated settings form to dynamic sizing based on the number of properties. Added admin group with the visibility toggled from the F12 key. The Admin group features View Errors, Visual Basic and Export Code. Autosort table on Add Days or Add Timeline.

1.0.0.0

5 years ago