-
Dec 23rd, 2020, 12:29 PM
#1
[RESOLVED] Excel: Get Holidays from opm.oov using html
The opm.gov website has list of US federal holidays that I would like to import into Excel. I know that I should be able to use the 'From Web' button on the Data tab, but I have a very old browser and it fails when I try to do it so I was wondering if there was an html approach.
-
Dec 23rd, 2020, 03:49 PM
#2
Re: Excel: Get Holidays from opm.oov using html
Do you have to get the data from the opm.gov web site? Any code you use may stop working when that web site changes, which could be 10 years from now or tomorrow.
Alternative idea:
https://www.extendoffice.com/documen...c-holiday.html
-
Dec 23rd, 2020, 03:56 PM
#3
Re: Excel: Get Holidays from opm.oov using html
Originally Posted by jdc2000
Do you have to get the data from the opm.gov web site? Any code you use may stop working when that web site changes, which could be 10 years from now or tomorrow.
That's true but I'm willing to risk that. And thanks for the link. I may use it.
-
Dec 23rd, 2020, 04:29 PM
#4
Re: Excel: Get Holidays from opm.oov using html
Thanks. I'm going to use the formula approach you pointed out.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|