Need help on save file name as from cell

[DKTRL]

Hello All !

Needs some help to solve my problem. need to know how click a button to automatically combine a few cell data and save it as the file name ?

The file name i want to save, is in this method.

( Date 2013-07-22 ) + ( Cheque No UOB000000 ) + ( ReceiverName ) + ( InvoiceNo L123456 ) + ( Payment Voucher Code ) + ( Amounts $1111111 )
______V5___________________E17___________________D11________________O9______________Add word ( PV )_____________W16

Sample File name : 2013-07-22_UOB000000_TransAuto_Inv778899_PV_$$$$$$$


I tried to add this code : FName = ActiveWorkbook.Sheets("Payment Voucher").Range =("V5&"_"&E17&"_"&D11&"-"&O9&"_"&"PV"&"_"&W16")

But getting error.


Than i tried to group all the cell data into cell (E11) and than select as range (E11), but when i tried to group it, the beginning the file name instead of i want it to be the date 2013-07-22_UOB........ it become 41113_UOB............



Can anyone help to solve my little problem ?

Thanks !

[Norie]

Use this formula, on the worksheet, to get the date in the right format.

Please Login or Register  to view this content.