$$Excel-Macros$$ file browser

2011-10-12 Thread airen
Hi experts, How to open a file from user via browse in VBA Thanks Akhilesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ file browser

2011-10-12 Thread Sanjib Chatterjee
reference : Microsoft Office 10 object libarary need to download Private Sub Command0_Click() Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) Dim vrtSelectedItem As Variant With fd If .Show = -1 Then For Each vrtSelectedItem In .SelectedItems MsgBox The path is:

Re: $$Excel-Macros$$ file browser

2011-10-12 Thread rajan verma
Hi, You can use Application.findFile(FileFilter) method. On Wed, Oct 12, 2011 at 3:56 PM, airen airen1...@gmail.com wrote: Hi experts, How to open a file from user via browse in VBA Thanks Akhilesh -- --

Re: $$Excel-Macros$$ file browser

2011-10-12 Thread airen
Thanks people. Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @