11 Feb 2014

Calendar 2014 v8 - with Moon-phases and Macro (VBA)

#10 Calendar 2014 v8 -with dates seasons and moon-phases and Macros (VBA)

I made a new version (v8) of my Excel Calendar, which is almost the same as v7, except it now includes the dates of the seasons (equinox, solstice) and moon-phases (new moon, full moon). These 'time events'  are reflected in some pictures in sheet-1 (Info), which are enabled or disabled depending on the actual date, or where you live, see fig.1, 2 for how the calendar looks like for some who lives north/south of the equator. To do this, I used macros and VBA (Visual Basic for Aplications, the basic language of Microsoft Office). That´s why the extension of the Excel now is xlsm (in stead of xlsx), which may cause a warning when you download it, but you can ignore that (so choose 'enable macros').
For more details on VBA, see e.g. :

http://msdn.microsoft.com/en-us/library/ee814735(v=office.14).aspx



fig.1: 11-2-2014: Summer in South


fig.2: 11-2-2014: Winter in North



Download-mirrors:

* Mirror #1:
https://skydrive.live.com/redir?resid=3F963E9F1A42D952!200&authkey=!AHwzHvWwLs60JBw&ithint=file%2c.xlsm

* Mirror #2:
https://drive.google.com/file/d/0BywxxSJoaUYxcUUzMmoyRXNrYTA/edit?usp=sharing

2 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Looks nice!

    ReplyDelete