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!

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