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!

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

Excel macro to select file

Status
Not open for further replies.

swamit

Technical User
Jan 9, 2002
16
US
Hello,
VBA pros help mee !!
During the open sequence of an Excel file, I need to give the user a dialog box to choose a file to open. I was thinking I can handle this with Auto_Open by calling another subroutine.
But I bring up the "File-Open" dialog box using a macro whereby the user can select the file he needs to open.
Help please !!
 
NOTE: This was answered in the MS Office Forum, as follows...


Is this line what you're looking for...

Application.Dialogs(xlDialogOpen).Show

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top