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

Top