file prompt
 

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

file prompt
 

Have a look at
Application.GetOpenFileName

this shows the standard Excel File open dialog.


---
Message posted from http://www.ExcelForum.com/