Copying data into new text file with script

J

jdame

My goal is to create a txt output from a excel worksheet.
I know little about build VB scripts and wanted to use a real life
problem that I have to help build up my knowledge.

The flow would be:

1. I would create button called 'Banana'
2. When user presses Banana button, vb script kicks off.
3. Script keys text 'Banana' into cell F2 of Sheet2
4. Script then calculates the worksheet
5. Script then COPY's contents of Sheet3, column L:L into txt file.
6. Script saves txt file as Banana.txt

Steps 3-6 are where I need the help with.

Thanks again to those that can help out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Script to Split up Worksheet into Multiple Sheets based on a Columnof Data 1
Copying data in a form into an alternative Workbook 1
Help with script: STARTING A NEW SUB.. (within sub?) 11
Create txt file with data manipulation and reorganization (macro) 0
Copying data to new workbook and saving as text delimited 1
Automated multiple text files into multiple sheets in one workbook 14
Merge Data with Criteria 3
Sorting Excel data from a .VBS script? 0

Top