hey,

workin on something for work and a bit stuck.

we get this file emailed to us everyday and i need it saved to the desktop with a static filename. example: the file will get send to us and be called ~1237.xls and I need to be able to run a macro to save it as book.xls.

im not sure how to save a macro into a file that will have its filename always changed. any help?

thanks!