Thread: Saving different files based upon data in particular column
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
DKY[_57_] DKY[_57_] is offline
external usenet poster
  
Posts: 1
Default Saving different files based upon data in particular column

Run-time error '13':

Type mismatch

then it highlights the following code.


Code:
--------------------
WBNew.SaveAs FileFolder & cell.Value & "_Surplus_" & FORMAT(Date, "yyyy-mmm-dd") & ".txt", FileFormat:=xlText _
, CreateBackup:=False
--------------------


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=392476

Reply With QuoteReply With Quote