Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to run on the "Active Sheet"
I am attempting to trigger a macro within a macro. The code I am using limits
me to the current file name as opposed to the "Active Sheet". The current file name in this case is "New Customer" but in the way that I want to use this macro it could be any file name, i.e. "Doe, John". In light of my elementary code below what can I change to allow this macro to trigger for the "Active Sheet" so that the file can be any name. Here is how the code reads now. Thanks: Sub RunPasteFinal() ' ' RunPasteFinal Macro ' Macro recorded 4/10/2006 by _ ' ' Application.Run "'New Customer.xls'!PasteFromFinal" End Sub -- David P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |