Export as CSV file!

Hi

i am not getting results as per my requirement & i also required some modification it.
half of code working fine, in column i, Q & M data is coping fine its static/fix data column A is also good and fine & other data will come up or copy from sam file to exported WBK!

below part isn't working!


column B of sam file will go to column N in exported file, column C of sam file will go to column W, column D of sam file will go to column R, column E of sam file will go to column O, column F of sam file will go to column K.

below is change/modification which i required.

when i run code i want one dialog box for pre number for column A, which number i will paste/write in that will become first digit of column A data for example i write 1 than 1 will be leading number of each cell if i leave blank than only column A data will copy as it is(only will remove dashes and spaces already in code) & total count of cell will be 11.
14311234560
14311234561
14311234562

second in column C sam file if there is only three letter than its will export with leading 0 only in sample like 0555, 0495

all other thing will remain safe.

i attached both files sam file and exported file(grv)

Please Login or Register  to view this content.

Adeel