Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Question better suited for Stack Overflow ( 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.