Results 1 to 4 of 4

How Can I Add/Subtract One Day from Hijri Calendar Using VBA

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Question How Can I Add/Subtract One Day from Hijri Calendar Using VBA

    Hello,

    I can Adjust Hijri Calendar (Add/Subtract one or two days) in Window by Changing the registry key using the following VBA Code

    Sub HijriAdjustmentDate()
    
        Dim wsh As Object
        Set wsh = CreateObject("WScript.Shell")
        
        wsh.RegWrite "HKEY_USERS\S-1-5-21-4059124821-1674896164-3570628022-1001\Control Panel\International\AddHijriDate", "AddHijriDate+2", "REG_SZ"
        Set wsh = Nothing
    
    End Sub
    But this doesn't affects Hijri Dates in Excel.

    How Can I Adjust The Hijri Calendar days in Excel using VBA?

    Hint:
    About : AddHijriDate Using Registry key modificaition
    https://learn.microsoft.com/en-us/wi...s/addhijridate

    I Found this article about Hijri Date Adjustment
    https://learn.microsoft.com/en-us/do...ijriadjustment

    How Can apply this / or something like this using excel vba?
    Last edited by exceere; 07-19-2023 at 02:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1