Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

summoning OPEN window from code

Status
Not open for further replies.
Luis939

Luis939

MIS
Feb 28, 2003
453
US
I'm having difficulty finding code that would summon the OPEN window in excel so that I can open a spreadsheet. I've seen code that would summon the save as window but not open. Can anyone help? Thanks!
 
Sort by date Sort by votes

If you enter:

set x = application.dialogs(

you will get a list of all the common dialog boxes, I forget what the open one is called.

You can then use x.show to display it.


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Open Word as ReadOnly 1
Replies
6
Views
381
Chriss Miller
C
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
732
huiettcm
huiettcm
remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
759
strongm
strongm
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
582
Andrzejek
Andrzejek
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
433
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top