Hi Theresa,

Try this code at the top of of your macro and it should allow you to
open up any file as it prompts you to select the file you want to use.
So just incase you don't remeber the name of the file. Excel will do an
open file function and you can pick the file you want.

myFile = Application.GetOpenFilename("Excel Files, *.xls")

Hope it works and good luck.

Oli

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!