- General
-
Ideas
0
Completed
i am attempting to set up a Hebrew calendar in columns in Excel.
I want to use the spreadsheet to record Hebrew history and current events. I have started with Metonic cycle 304 but it is taking me forever. Will you be able to assist me in setting up such a columnar spreadsheet containing all your calendar data? I am planning to eventually include all the cycles in this spreadsheet. Your help will be greatly appreciated.
Customer support service by UserEcho
An internet search turns up HebCalVb6, a VB6/VBA module to demonstrate how to convert a Hebrew date into the Gregorian date. It can be used within Visual Basic or within a Excel Macro.
http://www.dafaweek.com/HebCal/HebCalVb6.php
I used the VBA code in a previous Excel VBA application and it worked but was a lot to maintain. I would like to use WEBAPIs and use XMLHTTP calls in the VBA instead. I am looking for the syntax and I think the Greg to Heb and reverse calls are obvious. But I am looking for a call that is the functional equivalent of IsLeap in the VBA to determine if a Hebrew Year is or isn't a leap year without some complex code to figure out if Adar II is i the current year.