Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a number of workbooks, each containing a database with identical sheet
layouts. I want to use a single macro to copy a group of formulas from one workbook (Formulas.xls) that will copy to and then run against any of the databases (ex. 090918.xls). I have written a macro that works (test 4), but it only works on one database. Is there a way to have the macro select €œActiveWorkbook€ instead of the specific workbook I used when I wrote the macro? See underlined example below: ' Test4 Macro ' Macro recorded 3/9/2009 by Ralph Forbes ' ' Keyboard Shortcut: Ctrl+z ' Windows("Formulas.XLS").Activate Range("L15:Q17").Select Selection.Copy Windows("090918.xls").Activate ActiveSheet.Paste Range("L17:Q17").Select Application.CutCopyMode = False Thank you, Ralph Forbes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Workbooks using same macro | Excel Discussion (Misc queries) | |||
Need Help Creating a Macro Multiple Workbooks to One | Excel Worksheet Functions | |||
macro: copy multiple workbooks to multiple tabs in single book | Excel Programming | |||
Running the same macro to multiple workbooks | Excel Programming | |||
Accessing multiple workbooks through a macro | Excel Programming |