Hello All
I want to export CSV file from sam file both are attached.
Here is some requirement!
When I run code I want two dialog boxes will appear one by one.
Frist will for leading digit for column A (for example if i put 9 in first dialog box than 9 will be start of each number, like 94440991398, 94440991398, 94440991398 so on, if I put 0 than each number will carry leading 0 like 04440991398, 04440991398, 04440991398. (may leading zero will not appear in exported WPK(CSV) but when it will open in notepad leading zero should be there)
If I just leave blank than it will be exported with same data. Leading digit can be 1 or more in count!
Second dialog box for lead id for column B.
Column C will be static. file name and sheet name will be "Bulk"& path will be same for exported WBK where sam file will exist(in same folder).
Adeel
I want to export CSV file from sam file both are attached.
Here is some requirement!
When I run code I want two dialog boxes will appear one by one.
Frist will for leading digit for column A (for example if i put 9 in first dialog box than 9 will be start of each number, like 94440991398, 94440991398, 94440991398 so on, if I put 0 than each number will carry leading 0 like 04440991398, 04440991398, 04440991398. (may leading zero will not appear in exported WPK(CSV) but when it will open in notepad leading zero should be there)
If I just leave blank than it will be exported with same data. Leading digit can be 1 or more in count!
Second dialog box for lead id for column B.
Column C will be static. file name and sheet name will be "Bulk"& path will be same for exported WBK where sam file will exist(in same folder).
Adeel
Attachments
Last edited: