How to create a text file from column and FTP that text file to server
- by addi
I have workbook with 2 sheets (Sheet1 and sheet2). On sheet1 user will enter the data which will be populated in the column B and then column C will hold the values from Col A and B on sheet2.
I need to create a text file from the values in coloumn C on a click of a button and then upload(FTP) that file to a server.
So the sheet1 will have 2 buttons.
Button1 will save the excel file and create the text file in windows temp directory. e.g
text.xls
text.prop (text file whoch has all the values in column C on sheet2)
Button2 will upload (FTP) the text file (.prop) to a server.
Can anyone please send me the steps and VB code to achieve the above tasks?
Thanks in Advance
Addi