hi there,

i have a workbook and the user is asked to save the workbook under the
name "costs.xls"in a folder called "tests" in the current desktop.


how can i check using VBA that the user has saved the open workbook as
"costs.xls" and then check that he indeed saved it in the "tests"
folder on the desktop?


basically, how can i check that there is a folder "tests" on the
desktop with a file "costs.xls" in it ?


thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/