+ Reply to Thread
Results 1 to 4 of 4

Unable to obtain source for URLDownloadToFile

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    New Zealand
    MS-Off Ver
    365
    Posts
    44

    Unable to obtain source for URLDownloadToFile

    Hi Excel Forum,

    Does anyone know how to obtain a URL for URLDownloadToFile from what I believe is an HTMLMediaElement? I am manually able to obtain the link using navigating to developer tools\network\media within a browser, so surely it can be done. I've attempted to create an event below, but I am unsure whether this is the best approach or where to go from here.

    The following is what I have so far:

    Please Login or Register  to view this content.
    Inspecting the element reveals the following:

    Please Login or Register  to view this content.
    Any help is appreciated

  2. #2
    Forum Contributor
    Join Date
    02-25-2022
    Location
    Dallas, Texas
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Unable to obtain source for URLDownloadToFile

    IE is obsolete and almost all websites don't allow it. You could try SeleniumBasic.

  3. #3
    Registered User
    Join Date
    07-16-2019
    Location
    New Zealand
    MS-Off Ver
    365
    Posts
    44

    Re: Unable to obtain source for URLDownloadToFile

    Hi Mogul,

    I've now installed Selenium and launched Chrome within my excel module. I note the only tutorial I can find which explains how to download images and audio using VBA in selenium still uses URLDownloadToFile.

    Perhaps you or someone else knows whether it is possible to download an audio file from a web element without the "source" attribute?

    I suspect the element is an HTMLMediaElement, and I am unable to find an answer elsewhere.

  4. #4
    Registered User
    Join Date
    07-16-2019
    Location
    New Zealand
    MS-Off Ver
    365
    Posts
    44

    Re: Unable to obtain source for URLDownloadToFile

    While I was unable to solve this issue on my own, I was able to achieve my means with the following solution: https://github.com/NSBum/forvo_scraper_example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Unable to obtain a true addition with- odd excel fuction.
    By Sedge in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2022, 11:59 PM
  2. [SOLVED] PLease help ..... URLDownloadToFile not work
    By thiskeep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-30-2014, 05:15 AM
  3. Unable to use MATCH/INDEX to obtain value above and below in a column
    By ryanmc29 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-01-2014, 08:31 AM
  4. [SOLVED] URLDownloadToFile (API + 64 bit version)
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2013, 01:42 AM
  5. Unable to copy cells or obtain password to unprotect
    By pandra in forum Excel General
    Replies: 2
    Last Post: 09-21-2012, 04:58 AM
  6. [SOLVED] Unable to obtain Average due to cells contain #N/A value
    By PosseJohn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-06-2012, 07:31 AM
  7. Using URLDownloadToFile function from VBA
    By mathare in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2007, 05:21 PM

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