Need Help with VBA to run vba code on closed wb from active sheet

Dear Experts

I have xl workbook with vba code i want those macro from another workbook to closed workbook

I have Macro A,B,C,D,E...in closed workbook saved in path location. i want run these code from open workbook without open closed workbook

please find the attachment

Originally Posted by breadwinner

...I have Macro A,B,C,D,E...in closed workbook ... i want run these code from open workbook without open closed workbook

There is no way to run macros from an "unopened", closed workbook. The reason for this is that for any macro to work, Excel must first have an working, appropriate programming environment for scripts containing some code. This environment is created and launched when you open a given workbook, and you agree to run macros. In a closed workbook, this is "inactive".

Hello. They already explained to him that -yes or yes- the book that contains the macros has to be open.
The well-known "Solver" works like this: it's open... But you don't know it!

Then, if you want that book to go unnoticed, you can -temporarily- define it as Addin, run its macros and finally close it without saving variations in said hidden book like so:

PHP Code: 

Private Sub CommandButton1_Click()
Rem --------------------\
Rem I open it and define it as Addin:
Dim wb As Workbook
Application.ScreenUpdating = False
Set wb = Workbooks.Open(ThisWorkbook.Path & "\ClosedWb.xlsm", ReadOnly:=True)
wb.IsAddin = True

Rem --------------------\
Rem I run one of their macros:
Run "'" & wb.Name & "'!A"

Rem --------------------\
Rem And I close it without changes:
wb.Close False
End Sub 


Hi Boss Thanks for Code i want run code on closedwb get result in closedwb only not openwb pls help

Originally Posted by breadwinner

Hi Boss Thanks for Code i want run code on closedwb get result in closedwb only not openwb pls help

It keeps everything I've been through.
But if you want to modify cells in the hidden workbook or take data from the hidden workbook, whatever you have programmed in 'A' must reference itself.

If you want us to expand on the idea, then you should upload workbooks to the Forum that reflect a more realistic situation.