• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Export WBK (CSV)

Status
Not open for further replies.

adeel1

Member
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
 

Attachments

  • Bulk.csv
    347 bytes · Views: 4
  • sam(1).xlsm
    21.3 KB · Views: 3
Last edited:
If still in need : only column A is exported from source workbook ?​
« Column C will be static » : always same text or …​
A crystal clear initial explanation, a quicker and more targeted solution !
 
Status
Not open for further replies.
Back
Top