Running a Function or macro of child file from a Master file

[ravinder_tigh]

Hi Guys
I do need your help regarding one of my projects in which I ‘m trying out to run a function of a closed file from and active file In this case I do have 2 files Master and process
In both there’s a combo box control which help me revolve the data on basis of month As the case when combo box of process file is changed data is being revolved according to month
What I need to do is
When I change the combo box of MASTER file the change should reflect in the process file As function runs updates the process files value and file saved and closed

[ravinder_tigh]

Here’s the code for master file which I’m using to run function MB of process file

Please Login or Register  to view this content.

Here’s da code for process file

Please Login or Register  to view this content.

When I run the master file code with different file and functions it runs fine but

For this process file it generates an error Error no 1004 Macro couldn’t found “filename!function name”

Plz help me with this debugging I’m really tired up trying to sort this issue

I’d be really thankful

Regards
Ravinder S

[royUK]

You cannot run code from a closed file. maybe you could create an addin(*.xla) to hold the code.

[ravinder_tigh]

No I'm Not runnning the code from the closed file but i jst do it through master code
in which
i jst open the file
runs the application.run() part
save that opened file and close it

my area of concern is when i open the file it works fine but as code moves to next line
str = Application.Run(wbTarget & "!" & "MB", Num)
it created that error 1004
function dosen't exists

May be file could help u better understand

download both and run master file's code

Thanks And Regards,
Ravinder S

[ravinder_tigh]

i' had debugged the application and find out the problem when ever in master i suppy the file name as a string and if file name do hav spaces in between then it dosen't consider this as a [VBA]str = Application.Run(wbTarget & "!" & "MB", Num)[/VBA]



if i initialize wbtarget as workbook it could be done but i don't know how to set wbtarget with that file name could u plz help me with this issue



Regards,
Ravinder S