I recorded a macro that will save the file under another name, then
close it. It works great, but only on my computer.

The problem is that when you're using the file on another computer, the
macro won't work because the user has a different login name. The Save
destination includes my username, which is obviously different on
another computer. Is there a way around this?

Thanks!


--
mbmadiw
------------------------------------------------------------------------
mbmadiw's Profile: http://www.excelforum.com/member.php...o&userid=36153
View this thread: http://www.excelforum.com/showthread...hreadid=559288