Excel macro to select file 1

[swamit]

Hello,
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 Autpen 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 !!

 

[DaleWatson123321]

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

Application.Dialogs(xlDialogOpen).Show

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[swamit]

Yes sirr !!

Thank you very much

 

[RobBroekhuis]

Er.. Swamit, I think you meant to give the star to Dale, not to yourself - no?
Rob

 

[Loomah]

But you can't give yourself stars?!?!?!??
So who's responsible
I know I'm not very!
;-) If a man says something and there are no women there to hear him, is he still wrong?