Hit the button too soon. Just create a sub and put this in there, it will
open the selected file. Change or erase the file type section to suit what
file type you are getting.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"John Bundy" wrote:

mySheet = Application.GetOpenFilename( _
filefilter:="Excel Files (*.xls),*.xls", Title:="Choose Files",
MultiSelect:=False)

'Make sure a file was selected
If mySheet = "False" Then
MsgBox "No file selected, please select a file", vbCritical
Exit Sub
End If

Workbooks.Open mySheet
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"tnederlof" wrote:

Hey everyone, I have a big excel sheet with lots of formulas, macros,
ect but the one problem I have is that right now I have to load two
pages of data into the workbook each time I want to update everything.
I have to download the data and then I end up with two books...
Sheet_1.xls and Sheet_2.xls the first book has one sheet and needs
to be copied into the master book (sheet "raw data") and the second
book has one sheet which needs to be copied into the master book
(sheet "raw data2).

I would like to have a macro that would let the user in a dialog box
select where the files are located, have them open and copy their
sheets into the master. Is this possible? if so please help.

Thanks.