I don't know much about VBA and need to do the following tasks.
My question in short is "How do I create a text file from an Excel sheet column and FTP that text file to a server?"
I have workbook with 2 sheets (Sheet1 and sheet2). Sheet1 has the data entered by the user and sheet2 has that data mapped in a required format.
What I am looking for:
I need to put 2 buttons on sheet1 Button1 should do the following:
Saves the workbook with .xls extension creates a text file from the values (until the empty row) in sheet2 column C Displays a message once the above tasks are done or any error is returned
Button2 should do the following:
uploads the text file (created with button1 click) through FTP to a server Displays a message once the file is uploaded or any error is returned
Can anyone please help to achieve the above tasks?