Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I don't know much about VB and need to do the following tasks.

My question in short is "How to create a text file from a 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 (untill 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?

Thanks in Advance


share|improve this question
Question better suited for Stack Overflow (stackoverflow.com) sense you want VB code, but you still do not ask any direct questions and its very vague. Just break it down into segments and tackle them one by one. –  Logman Jun 30 '12 at 2:31
updated my question let me know, if it makes sense. Thanks for your input –  addi Jun 30 '12 at 3:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.