Results 1 to 4 of 4

Thread: [RESOLVED] Excel: Get Holidays from opm.oov using html

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Resolved [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.

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,393

    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

  3. #3

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: Excel: Get Holidays from opm.oov using html

    Quote Originally Posted by jdc2000 View Post
    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.

  4. #4

Posting Permissions

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



Click Here to Expand Forum to Full Width