+ Reply to Thread
Results 1 to 5 of 5

Coding for downloading a text file

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Coding for downloading a text file

    I am trying to write a kind of general procedure to load down a text file into my application.
    I have got this far.
    Please Login or Register  to view this content.
    E9 has the value "Budget 2016-2017.Txt"
    E7 has the value "U:\!EVERYBODY\SALESTATISTICS\TEXTFILES"

    I get a compile error on this and I have not been able to find out why. Can anyone help ?

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Coding for downloading a text file

    Hi there,

    Try using a comma instead of the ampersand:

    Please Login or Register  to view this content.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Last edited by Greg M; 10-17-2017 at 01:44 PM. Reason: Variable name corrected

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Coding for downloading a text file

    Syntax error. Separate arguments with "," not "&"


    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Coding for downloading a text file

    GregM and 6StringJazzer,
    Sorry that I have not acknowledged your help sooner. You both gave me the same reason (which was encouraging) for my trouble and you were both dead right.
    Mant thanks
    John

  5. #5
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Coding for downloading a text file

    Hi again,

    Many thanks for your feedback and also for the Reputation increase - much appreciated!

    You're welcome - glad I was able to help.

    Best regards,

    Greg M

+ 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. Downloading file from SFTP
    By paulzov in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2018, 05:20 PM
  2. Replies: 9
    Last Post: 12-23-2016, 10:54 PM
  3. [SOLVED] VBA Query for Downloading a XLS File
    By sathis in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-17-2015, 07:50 AM
  4. downloading file from Web
    By headhair in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2014, 07:28 AM
  5. Task Scheduler Downloading an Empty, Bad File Before Actual File Exists...Not Good
    By jamesdeuce in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-23-2014, 01:25 PM
  6. Urgent help for writing text file to excel using macro coding
    By praveenvinay in forum Excel General
    Replies: 0
    Last Post: 06-26-2012, 09:02 AM
  7. Help with Downloading A CSV file
    By kchappy32 in forum Excel General
    Replies: 0
    Last Post: 06-05-2012, 03:24 PM

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