+ Reply to Thread
Results 1 to 3 of 3

macro from FTP Folder

  1. #1
    Registered User
    Join Date
    08-14-2019
    Location
    Chicago
    MS-Off Ver
    online
    Posts
    2

    macro from FTP Folder

    Hi Everyone,

    I am new to VBA, but really want to learn. I have searched, tried numerous ways, but I can't seem to find the solution.

    I want to be able to:

    pull my csv invoices from an FTP server running a macro.

    Host: ftp.***ecommerc*****
    Port: 22
    Protocol: SFTP/SSH
    USER: *********
    PASS: *******
    PATH: From/Gmail/Invoice/Archive

    From here, I have 52 files (one invoice per week), and I want to load them all into an excel file.

    A few issues that need to be addressed if the solution is found:

    The header row is not included and some generic company information is inserted on row 1 (data starting on row 2) I added the column headings in my example file in row 1.
    The tracking numbers in columns L & M need to be converted into text to avoid scientific notation from being displayed
    In column V, data that contains "DEL Confirm -W/Label Dom" is duplicate data from the row above, so I'd like to remove the rows that contain that text
    Date is listed in the format of "YYYYMMDD" or "20190925" and would like to be able to avoid using an additional step, such as using =DATE(LEFT(I2,4),MID(I2,5,2),RIGHT(I2,2))

    Any help on this would be greatly appreciated!
    Attached Files Attached Files
    Last edited by mrhesse1975; 11-12-2019 at 11:04 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,146

    Re: pull my csv invoices from the FTP server that is connected to my mac

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: As you are new here I did it for you. Please read forum rules

  3. #3
    Registered User
    Join Date
    08-14-2019
    Location
    Chicago
    MS-Off Ver
    online
    Posts
    2

    Re: macro from FTP Folder

    Thank you for your advice. I edited the title.

+ 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. Replies: 3
    Last Post: 08-11-2017, 03:10 AM
  2. Replies: 1
    Last Post: 06-12-2017, 09:20 PM
  3. Replies: 5
    Last Post: 08-06-2014, 01:10 PM
  4. Replies: 1
    Last Post: 05-02-2014, 03:05 PM
  5. [SOLVED] Function that concatenates multiple sub-project descriptions based on project code
    By markbpi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 06:49 PM
  6. [SOLVED] Insert Blank Rows between sorted projects, Subtotal project to the right of final project.
    By ZAC7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2012, 04:08 AM
  7. Replies: 1
    Last Post: 10-18-2005, 11:05 AM

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