I have this code linked with a button on an excel sheet

Sub Refresh()
Workbooks("IDS Time Sheet.xls").RefreshAll
End Sub

The problem is that the end user will be copying this file and renamin
it so that "IDS Time SHeet.xls" would end up becoming another name lik
Username2-4-04.xls or something to that effect. Is there a way t
achieve the same thing no matter what the workbook name would end u
being?

Thanks as always
Jason Sel

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