Vba Help Required

[Premanshu]

Hi,

I am actually creating a macro which when triggered will pull a specific file as per User's selection and perform certain tasks on that.

Can i instruct my macro such a way that when it is triggered a pop appears with a "Browse" button on it through which the user can browse into the system and locate the file he wants to be opened and worked upon by the macro.

Any help on this would be highly appreciated....


Thanks in advance...

Regards
Premanshu.

 

[shyrath]

try something like this:

Sub Get_Data()

Dim wb1 As String

wb1 = ActiveWorkbook.Name

FileToOpen = Application.GetOpenFilename _
(Title:="Please choose a file to open", _
FileFilter:="Excel Files *.xls (*.xls),")
''
If FileToOpen = False Then
MsgBox "No file specified.", vbExclamation, "No file"
Exit Sub
Else
Workbooks.Open FileName:=FileToOpen



End If
End Sub

 

[Makrini]

Sub tester()
    Filename = Application.GetOpenFilename()
    If Filename = 0 Then
        MsgBox ("Cancelled")
        Else: MsgBox (Filename)
    End If
End Sub

This should get you started

 

[Premanshu]

Thank you so much Shyrath and Makrini....... you guys were a great help for me.
Shyrath i also went through your blog it's awesome mann. Looks like i am in touch of a excel champ.... would again trouble you if got stuck into something.

Thanks a lot again both of you guys....

God bless you....

Premanshu