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