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 @ http://www.linkedin.com/groups?gid=
Hi,
You can use Application.findFile(FileFilter) method.
On Wed, Oct 12, 2011 at 3:56 PM, airen wrote:
> Hi experts,
> How to open a file from user via "browse" in VBA
> Thanks
> Akhilesh
>
> --
>
> --
> Some impor
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: " &
