Open form from another workbook

  • Thread starter Thread starter Keith74
  • Start date Start date
K

Keith74

Hi All

I'm having a friday moment. When one for closes i want to close that
workbook and show the menu form in the previous workbook.

Application.run "Main Menu.xls!ShowForm" just returns an error (can't
find).

Any thoughts?

cheers

Keith
 
Try enclosing the filename in single quotes.

Application.Run "'Main Menu.xls'!ShowForm"
 

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

Similar Threads

CLOSE WORKBOOK FROM MENU WITH USERFORM 1
Run code from another workbook 7
closing another file by code causes failure to run workbook activate event 2
Calling subroutine defined in another workbook (autostart workbook) 5
Calling Form Routine from Another Workbook 1
referencing controls in userform from a different workbook 2
Attempting to call a sub from another wb using a Userform option b 2
Selecting a specific sheet by codename in an opened workbook (XL03 2

Back
Top