Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have this line in several macros (7) to be exact.
Each one of these macros is called when another Macro is run (Changing something on a sheet). The macros are exactly the same except this line where this line says "Before_I_Update" Is there a way to pass "Before_I_Update" from the macro that is calling it? That way I can have only 1 macro that runs this code and pass the "string" to it. BTW I have three workbooks with the same amount of macros with this code. ThisWorkbook.Path & "\Backup\Loja\Work\Before_I_Update (" & strSH & ")" & Format(Now, " dd-mm-yy hh-mm-ss") & ".xls" -- Thank You in Advance Ed Davis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text format - setting text colour with code | Excel Discussion (Misc queries) | |||
Macro - Fixed text code needs replacing with variable text | Excel Discussion (Misc queries) | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Passing a row to a function | Excel Worksheet Functions | |||
Passing a UDF as an argument to a UDF | Excel Discussion (Misc queries) |