موضوع‌ها
۰
فورک‌ها
۱
ستاره‌ها
۱۱
تاریخ ایجاد
۲۱ اسفند ۱۳۹۴
آخرین بروزرسانی
حدود ۶ سال قبل

Microsoft VBA Code for Jalali(Shamsi) Calendar

This code is VBA functions for convert jalali date to Gregorian date and vice versa. Jalali calendar is also known as Jalali, Persian, Khayyami, Khorshidi, Shamsi calendar You can use this code in MS Access, MS Excel or other vba compatible environments Excel example provided in code if you know Persian you can read "Persian Read Me.txt".

you can find tutorial about how to write vba in ms excel (http://www.tutorialspoint.com/vba/vba_excel_macros.htm)

Origin code

this code is just vba port for js jalali js code (https://github.com/jalaali/jalaali-js) by Behrang (https://github.com/behrang)

Description

you can find useful comments in code


Private Sub CommandButton1_Click()
Dim nowDate As Date
nowDate = Date
 
Dim jalaliDateArray1
jalaliDateArray1 = toJalaaliFromDateObject(nowDate)
 
'MsgBox "Now= " & jalaliDateArray1(0) & "/" & jalaliDateArray1(1) & "/" & jalaliDateArray1(2)

Dim gregorianDate As Date

gregorianDate = toGregorianDateObject(1394, 12, 19)

MsgBox "Date Object From Jalali= " & gregorianDate

Dim jalaliDateArray
jalaliDateArray = toJalaali(2016, 3, 9)

'MsgBox jalaliDateArray(0) & "/" & jalaliDateArray(1) & "/" & jalaliDateArray(2)

Dim gregorialDateArray
gregorialDateArray = toGregorian(1394, 12, 19)

'MsgBox gregorialDateArray(0) & "/" & gregorialDateArray(1) & "/" & gregorialDateArray(2)

End Sub

VBA Tutorial

You can find an elementary vba tutorial in "Persian VBA Elementary Tutorial.pdf". this is not organized or complete tutorial . it is just elementary tutorial written for a friend in instance messenger .

License

MIT

پروژه‌های مشابه

پروژه ای یافت نشد.