View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Save as Macro working for one computer but not the other?

Hi Infinity,

What error message is received on the problematic computer?


---
Regards,
Norman



"Infinity" wrote in
message ...

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 colleagues
computer. Anybody know what's wrong with the above code.

Thanks in advance


--
Infinity
------------------------------------------------------------------------
Infinity's Profile:
http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=527462