+ Reply to Thread
Results 1 to 2 of 2

External data from a web URL

  1. #1
    Forum Contributor Marco-Kun's Avatar
    Join Date
    04-14-2009
    Location
    Holland
    MS-Off Ver
    Dutch:2007
    Posts
    298

    External data from a web URL

    Hello everyone,

    Right now I'm using the following code to retrieve data from an external text file to insert it in a userform.
    This text file is located in the same directory as the currently opened document.

    Please Login or Register  to view this content.
    What I would like to do is change the path for the Filename to a web URL, something like: "http://www.server.nl/folder/folder/test.txt"
    How can I do this? When I replace the current Filename code to this it doesn't work. It returns a "Bad file name or number" error.

    Please Login or Register  to view this content.
    Thanks in advance.

    Marco

  2. #2
    Forum Contributor Marco-Kun's Avatar
    Join Date
    04-14-2009
    Location
    Holland
    MS-Off Ver
    Dutch:2007
    Posts
    298

    Re: External data from a web URL

    I found a solution by using a post Leith Ross posted here:
    http://www.excelforum.com/excel-prog...xt-file.html#3

    [SOLVED]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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