Open form from another workbook

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
 
V

Vergel Adriano

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

Run code from another workbook 7
populate a combobox based on unique values in another workbook 16
closing another file by code causes failure to run workbook activate event 2
Ignoring a runtime error 1
CLOSE WORKBOOK FROM MENU WITH USERFORM 1
Calling subroutine defined in another workbook (autostart workbook) 5
APPLICATION OR USER DEFINED ERROR 3
referencing controls in userform from a different workbook 2

Top