my macro calls a file to be copied into the spreadsheet.

Workbooks.Open Filename:= _
"C:\Documents and Settings\lhensel\My
Documents\data file.xls"
Sheets("ITEM370").Select
Sheets("ITEM370").Move Befo=Workbooks("macro
file").Sheets(1)

the data file name is sometims different and the sheet
sometimes changes too. is their a way to prompt for a
filename?

thanks,

larry