1.I wish to create a folder everytime I add a new customer in my customer list
2.For example, when I add a customer using the FORM under DATA, I enter the
customer code (eg ABC,BUZ,CKF...), customer name,customer address.The
customer code is in column A, starting at A2
3.For the new customer,by using a micro ,I want to create a new folder (eg.
"K:\TRIALQUOTATIONS\BUZ") .
4.In future the customer's quotations will be filed in this folder.
5.I had written the following micro, which is giving "run time error 438"

Sub CREATECUSTOMERFOLDER()

ActiveWorkbook.CreateFolder FolderName:="K:\TRIALQUOTATIONS\" &
Sheets("CUSLIST").[A2]
6.Please advise suitable changes in the micro.
End Sub
excelforautomatinginvoicing