| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Paste to different workbooks
I have a Macro for extracting price options from a large pricelist with
several sheets. The Macro always copies to a workbook "MachineQuote1". How can I make the macro copy to any selected workbook? I am a novice at working with VB and Macros. The code is currently:- Range("A1").Select Selection.AutoFilter Range("A1").Select Selection.AutoFilter Field:=1, Criteria1:="Y" Range("A1:O22").Select Selection.Copy Windows("MachineQuote1").Activate ActiveCell.Select ActiveSheet.Paste ActiveCell.Select Windows("RembrandtPriceList2006+AMJMPrices-17May06.xls").Activate Application.CutCopyMode = False Selection.AutoFilter ActiveCell.Select Windows("MachineQuote1").Activate End Sub -- Thanks Mannie G |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Automatic copy between two workbooks | Excel Worksheet Functions | |||
| How can I set up automatic path/file name for new workbooks? | Excel Discussion (Misc queries) | |||
| automatic links to other workbooks | Excel Discussion (Misc queries) | |||
| Automatic creation of an overview using several workbooks | Excel Programming | |||
Threaded Mode
