Attempting to call a sub from another wb using a Userform option b

  • Thread starter Thread starter OffDev
  • Start date Start date
O

OffDev

Please assist.

I have an userform that has several options button each calls a sub proc
from another workbook
I am getting run-time error 1004 Method Run of object_Application failed
when I click on the button when the other workbook close .

When the workbook is open I am getting run-time error 1004 Cannot run the
macro wbMain.xlsm!cmdOpenfile. The macro may not be available in this
workbook or all macros may be disabled.but with a different reason.
My macros options are enabled and has trusted access.

I am baffled because the code is very simple:

Application.run "wbMain!subproc"

Thanks
Offdev
 
Am I guessing correctly that wbMain is a workbook variable?

If so then try the following
Application.Run wbMain.Name & "!subproc"

Or maybe you have just used wbName as an example of your workbook name in
which case if your workbook name has any spaces in the name then enclose the
workbook name in single quotes.

Application.run "'wb Main'!subproc"
 
An afterthought.

If wbMain is a workbook variable then if there are any spaces in the
workbook's name then you will also need to include the single quotes in the
line of code as per one of the following examples.

Application.Run Chr(39) & wbMain.Name & Chr(39) & "!subproc"

Application.Run "'" & wbMain.Name & "'" & "!subproc"
 
Back
Top