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!
Bookmarks