tlchan
05-31-2008, 07:50 PM
Hi all VBA experts,
I have a project task to export the new database to existing database of different file format. However the main problem I'm facing the is the SSE No in the new database is in the form of alphnumeric with specific no of charaters but the old database are in numeric only.
In order to export the new database to existing, I need to convert the SSE No from alphanumeric to numeric and copy to new sheet before exporting. The converted SSE No I required is only in numeric without any preceding zero or numbers. e.g ENV010980001 to become 1. Attached sample of working file. :dunno
I have a project task to export the new database to existing database of different file format. However the main problem I'm facing the is the SSE No in the new database is in the form of alphnumeric with specific no of charaters but the old database are in numeric only.
In order to export the new database to existing, I need to convert the SSE No from alphanumeric to numeric and copy to new sheet before exporting. The converted SSE No I required is only in numeric without any preceding zero or numbers. e.g ENV010980001 to become 1. Attached sample of working file. :dunno