Posted to microsoft.public.excel.programming
|
|
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
|