Calling Private Sub from UserForm code

[powerpackinduo]

I have a macro in a workbook with code in the Open event that opens a workbook: daily.xls

In the daily.xls file there is a UserForm with code.

In the UserForm code there are private subs. (private sub name: Update)

How do I have my initial workbook open the daily.xls file and run the private subs found in the userform code?

I've tried the following in the open event:

Workbooks.Open "C:\daily.xls"

Application.Run ("'daily.xls'!Update")

and I get the message: The macro ''Daily.xls'!Update' cannot be found.

 

[NdNoviceHlp]

Move the sub to Module code. HTH. Dave

 

[powerpackinduo]

If I do that then they are not available to the Daily.xls userform when that file is used by itself.

Is there any other way?

 

[NdNoviceHlp]

They are available to the userform in Module code if you change the sub to Public not Private. Dave

 

[powerpackinduo]

I wanted to keep them private if possible.

 

[NdNoviceHlp]

A private sub in userform code is available only to the userform. To run a sub in another workbook the sub must be in module code. A private sub in module code is only available to the module. A public sub in module code is available to the whole wb. Far as I know, the sub has to be public and in module code for it to be ran from another wb. Not sure why you're reluctant to have public subs? Dave

 

[RoryA]

It is pretty much a contradiction in terms to want to keep your routines private but be able to call them from elsewhere...