Macros: Copying from different document, saving in multiple forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

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

Need Macro... 8
Copy from Excel to Word 2
Saving a Word document as PDF from en Excel macro 2
Formatting and copy or copy and formatting ?? 2
Lose macros before saving 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro for Creating Word Document!! 5
save file using information from a cell 1

Back
Top