Open Other File and Run Marco with (Application.Run )

[nanuutm]

i need to open FILE B and run macro in FILE B

My Code

Sub Marcodd()
Application.Run "C:\Users\THJunsomPa\Desktop\3.Master ok Sell-out Promotion_Mar'16.xlsm!B_Clear"
End Sub

This Code is open File but cannot run macro[B_Clear] in file

This Error

 

[Domenic]

Try enclosing the path and filename within apostrophes...

Application.Run "'C:\Users\THJunsomPa\Desktop\3.Master ok Sell-out Promotion_Mar'16.xlsm'!B_Clear"

Hope this helps!

 

[nanuutm]

Try enclosing the path and filename within apostrophes...

Application.Run "'C:\Users\THJunsomPa\Desktop\3.Master ok Sell-out Promotion_Mar'16.xlsm'!B_Clear"

Hope this helps!

Thank Domenic

now i can fix it

i must change file name to simple no ' " " can work

 

[Domenic]

You're very welcome!