View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Roberts[_2_] Ken Roberts[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.