Macros: Copying from different document, saving in multiple forms
 

Can I do the following within a macro:

1. Open a second Excel document to copy a column from it; return to the
working document, paste the column of data in it.

2. Run a variety of calculations (already doing this).

3. Eliminiate worksheets within the primary document (with useless
information).

4. Add a worksheet so that I can save once in Excel format, once in text
format and once in csv format.

Thanks.

Macros: Copying from different document, saving in multiple forms
 

Try it. Record the actions as you carry them out manually.

You may need to modify the code produced but it will you a start.

Regards

Trevor


"Ken Roberts" <Ken wrote in message
...
Can I do the following within a macro:

1. Open a second Excel document to copy a column from it; return to the
working document, paste the column of data in it.

2. Run a variety of calculations (already doing this).

3. Eliminiate worksheets within the primary document (with useless
information).

4. Add a worksheet so that I can save once in Excel format, once in text
format and once in csv format.

Thanks.