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
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:
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
--
--
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 @