excel vba to figure out the time for shabbat or yom tov

[BORUCH]

hi

I'm looking for an excel vba that can figure out the Shabbat or yom tov candle lighting times in new York city, by city by looking up a certain date

any help is appreciated

 

[alansidman]

You might try this Mcode in Power Query weekly. Once created, then on a weekly basis Refresh the query. It will give the current week information and the following week.

let
    Source = Web.BrowserContents("https://www.chabad.org/calendar/candlelighting_cdo/locationId/10023/locationType/2/jewish/Candle-Lighting.htm"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".secular_date"}, {"Column2", ".jewish_date"}, {"Column3", ".align_right .bold"}, {"Column4", ".time"}}, [RowSelector=".day"]),
    #"Filtered Rows" = Table.SelectRows(#"Extracted Table From Html", each ([Column3] = "Light Candles at"))
in
    #"Filtered Rows"

 

[BORUCH]

You might try this Mcode in Power Query weekly. Once created, then on a weekly basis Refresh the query. It will give the current week information and the following week.

let
    Source = Web.BrowserContents("https://www.chabad.org/calendar/candlelighting_cdo/locationId/10023/locationType/2/jewish/Candle-Lighting.htm"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".secular_date"}, {"Column2", ".jewish_date"}, {"Column3", ".align_right .bold"}, {"Column4", ".time"}}, [RowSelector=".day"]),
    #"Filtered Rows" = Table.SelectRows(#"Extracted Table From Html", each ([Column3] = "Light Candles at"))
in
    #"Filtered Rows"

Hi
I would rather some udf function if it's possible