I am writing a macro in which I am passing the name of a file to a
function.
If I pass just the name of the file everything goes fine, but if i give
the ull path, it shows me error.

i.e .
pass("temp.xls") - works fine
But pass("c:\temp.xls") - shows error :"Run time error 9, Subscript
out of range"

DO we need to format the path in some special way or ???

Regards,

Jatz


--
JAtz_DA_WAY
------------------------------------------------------------------------
JAtz_DA_WAY's Profile: http://www.excelforum.com/member.php...o&userid=26684
View this thread: http://www.excelforum.com/showthread...hreadid=400153