How do i create a macro that saves the filename that is equal to a cell in the sheet?
 

How do i create a macro that saves the filename that is equal to a cell
in the sheet?


--
Chukka
------------------------------------------------------------------------
Chukka's Profile: http://www.excelforum.com/member.php...o&userid=29365
View this thread: http://www.excelforum.com/showthread...hreadid=491092

How do i create a macro that saves the filename that is equal to acell in the sheet?
 

with activeworkbook
.saveas filename:="C:\myfolder\" & .worksheets("sheet99").range("z99").value _
& ".xls", fileformat:=xlworkbooknormal
end with

No checking at all!

Chukka wrote:

How do i create a macro that saves the filename that is equal to a cell
in the sheet?

--
Chukka
------------------------------------------------------------------------
Chukka's Profile: http://www.excelforum.com/member.php...o&userid=29365
View this thread: http://www.excelforum.com/showthread...hreadid=491092

--

Dave Peterson