How to call Private Sub using Application.Run

[chuttus]

I’m looking for a code to trigger a macro located in a different workbook.
The current code I’m using is..

Application.Run ("'Data Lookup.xlsm'!Main")

Where ‘Main’ is the macro that I want to trigger, looks like ‘Main’ is set up as Public Sub in the ‘Data Lookup’ workbook but there are other Private Sub located… Private Sub Dump(), Private Sub Login(), Private Sub Logout().
My question is does above Application.Run code trigger all stated Private Sub? If not what code should I use to trigger Public sub and all Private Subs?

Thanks!

[xlnitwit]

That code will only run the Main routine (which may or may not run the others). To run a different one, just change the name of the routine in that code.

[chuttus]

I tried calling out one of the Private Sub Dump(), using below code and it gave me an error "Object variable or With block variable not set"

Application.Run ("'Data Lookup.xlsm'!Main")
Application.Run ("'Data Lookup.xlsm'!Dump")

[xlnitwit]

That suggests the error occurred in the Dump routine. Given that it is private, it's presumably not intended to be called externally.

[chuttus]

So, how can I trigger Dump and other Private Sub() in the 'Data Lookup' workbook, without changing anything to that file?

[xlnitwit]

That is how you call it. My point is that the routine may not work if called externally.

[chuttus]

That means I cannot trigger any routine called out in Private Sub() and it has to be Public

[xlnitwit]

No it does not. You can call it but if it is designed to be called only internally (eg depends on some variables being previously set) then it won't necessarily work when called from elsewhere.