Using Input Boxes IN VBA to open files.

[Guest_imported]

Hi
I was hoping somebody could help me with this. I am trying to create a form or someother way of making the user input a file name and then use it to open that file using VBA. Also if i want to take some specific information from one excel sheet and use it in another ....how can i do that.
Thanks
HS

 

[vbMax]

To use the Open File Dialog box...

Filename = Application.GetOpenFilename
If Filename <> False Then
Workbooks.Open Filename:=Filename
End If


To use a simple input box...

Filename = InputBox(&quot;Enter the file name:&quot;, &quot;Open File&quot
On Error Resume Next
Workbooks.Open Filename:=Filename