Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Forms | Excel Programming | |||
Slow saving when adding VBA forms | Excel Discussion (Misc queries) | |||
Saving Excel document without macros | Excel Programming | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
saving information entered onto forms | Excel Programming |