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

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
 
O

OssieMac

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"
 
O

OssieMac

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top