I have the following macro.

ACTIVEWORKBOOK.SAVEAS \"K:\COMM\INVEST\DAILY NBV NEW CALCULATIONS\\"
\"JAMES-DV\" & RIGHT(DATE, 2) & MID(DATE, 4, 2) & LEFT(DATE, 2

This macro is working fine on my computer but not on my colleague
computer. Anybody know what's wrong with the above code.

Thanks in advanc

--
Infinit
-----------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...fo&userid=3272
View this thread: http://www.excelforum.com/showthread.php?threadid=52746