I need to create a new folder in code based upon the first
5 characters of a newly created table omitting the three
characters tbl. Eg. So the new table is tblSuppliers. A new
folder on the hard disk would become c:\database\suppl and
so on.

Any help anyone greatly appreciated.