I have several files on Co Network and would like to build a Macro
(behind a button) that would auto assign file name (using workbook cell
reference - one identify name and second cell date) and when button is
pressed it would perform save or saveas function re-directing that file
to a specific network directory. I have tried several combinations with
both save and saveas but in save it will not allow me to reference
cell's from which i woulod like to enter name and with saveas function
it allows me to assign name but it will not recognize network address
where i would like to save the file. Also, with saveas function it
closes original file and opens saved as file and I'm trying to have
user stay in original file that was open. Any help will be greatly
appreciated

Thanks
Arthur


--
knosalaa
------------------------------------------------------------------------
knosalaa's Profile: http://www.excelforum.com/member.php...o&userid=32204
View this thread: http://www.excelforum.com/showthread...hreadid=519534