Excel macro CSV issue -

-

im using excel macro generates csv file data upload gmail contacts. when file uploaded gmail contacts, mobile number , work number come correctly persons name comes in notes box "first name: yash". im attaching sample csv file generated macro.

download sample csv here

im using following macro generate csv's:

sub getcsv() application.screenupdating = false csvnewsheet dim myrange range dim numrows integer set myrange = activesheet.range("a:a") numrows = application.worksheetfunction.counta(myrange)     range("e1").select     activecell.formular1c1 = "first name"     range("e2").select     activecell.formular1c1 = "=concatenate(reports!r[5]c2,"" "",reports!r[5]c1)"     range("e2").select     selection.autofill destination:=range("e2:e" & numrows + 1)     range("e2:e3").select     columns("e:e").entirecolumn.autofit     hide_format     exporttocsv     delsht     application.screenupdating = true end sub   sub hide_format() ' ' hides name & place columns , removed formatting '  '     columns("a:a").select     selection.delete shift:=xltoleft     selection.delete shift:=xltoleft     columns("c:c").select     selection.cut     columns("a:a").select     selection.insert shift:=xltoright     range("a1").select     range(selection, selection.end(xldown)).select     range(selection, selection.end(xltoright)).select     selection.borders(xldiagonaldown).linestyle = xlnone     selection.borders(xldiagonalup).linestyle = xlnone     selection.borders(xledgeleft).linestyle = xlnone     selection.borders(xledgetop).linestyle = xlnone     selection.borders(xledgebottom).linestyle = xlnone     selection.borders(xledgeright).linestyle = xlnone     selection.borders(xlinsidevertical).linestyle = xlnone     selection.borders(xlinsidehorizontal).linestyle = xlnone     selection.interior        .pattern = xlnone        .tintandshade = 0        .patterntintandshade = 0     end end sub       sub csvnewsheet()     dim myrange range     dim numrows integer     set myrange = worksheets("reports").range("a:a")     numrows = application.worksheetfunction.counta(myrange) + 3     sheets.add.name = worksheets("reports").range("a2").value & "_csv"     worksheets("reports").range("a6:d" & numrows).copy destination:=worksheets(worksheets("reports").range("a2").value & "_csv").range("a1")     worksheets(worksheets("reports").range("a2").value & "_csv").columns("a:d").autofit     end sub        sub exporttocsv()     dim mypath string     dim myfilename string      myfilename = worksheets("reports").range("a2").value & "_csv"     if not right(myfilename, 4) = ".csv" myfilename = myfilename & ".csv"      worksheets(worksheets("reports").range("a2").value & "_csv").copy      application.filedialog(msofiledialogfolderpicker)         .title = "select folder save csv"         .allowmultiselect = false         .initialfilename = "" '<~~ start folder path file picker.         if .show <> -1 goto nextcode         mypath = .selecteditems(1) & "\"     end      nextcode:      activeworkbook         .saveas filename:=mypath & myfilename, fileformat:=xlcsv, createbackup:=false         .close false     end     end sub       sub delsht()         application.displayalerts = false         sheets(worksheets("reports").range("a2").value & "_csv").delete         application.displayalerts = true     end sub

this macro generates new sheet data required changes , save csv , delete sheet.

i dont know im going wrong...but contact names dont come in gmail... ive tried various other methods still didnt work...

please help!

this how gmail suggests format of csv file.

-

gmail csv

this how have yours formatted.

enter image description here

you may have have formatted way gmail suggests.


Comments

Post a Comment

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

-
i want check scene image against 2 train images. that, detect features , compute descriptors of both training images. before detecting, computing , matching scene image, delete matches of train1 , train2. because these matches won't facilitate matching of scene image train1 , train2. so, match train1 train2 , vector of matches trainidx , queryidx. how can delete these matches in keypoints-vector , descriptor matrix of train1 , train2? best regards, dwi i have done below: std::vector<cv::keypoint> keypoints[2]; cv::mat descriptor[2]; std::vector< cv::dmatch > matches; /* write code generate keypoints, descriptors , matches here... keypoint[0] -> train image 1 keypoints keypoint[1] -> train image 2 keypoints descriptor[0] -> train image 1 descriptors descriptor[1] -> train image 2 descriptors matches -> matched between train image 1 , 2 */ // logic keep unmatched keypoints , corresponding descriptor
Read more

java - Could not locate OpenAL library -

-
i writing game using slick2d library, uses lwjgl. lwjgl version 2.9.3. using netbeans 8. i tried adding sounds game, example music track on main menu. problem is, exception when run game, despite game still compiling , running except sound of course: sat mar 21 01:23:57 edt 2015 error:could not locate openal library. org.lwjgl.lwjglexception: not locate openal library. @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:102) @ org.lwjgl.openal.al.create(al.java:206) @ org.newdawn.slick.openal.soundstore$1.run(soundstore.java:295) @ java.security.accesscontroller.doprivileged(native method) @ org.newdawn.slick.openal.soundstore.init(soundstore.java:292) @ org.newdawn.slick.music.<init>(music.java:156) @ org.newdawn.slick.music.<init>(music.java:75) @ view.mainmenu.init(mainmenu.java:58) i didn't include rest of error states error happens in game code. the
Read more

sorting - opencl Bitonic sort with 64 bits keys -

-
i used nvidia sdk bitonic sort , works great me. 32 bits (uint) need ulong keys. have typically 2^14 keys @ time , power of 2. searched on not find kernel designed ulong. i tried modified nvidia sdk bitonic sort using ulong keys not work. kernel not crash after de call clenqueuendrangekernel got error : cl_invalid_command_queue can tell me how modify bitonic sort or radixsort, or can sort ulong keys? i running nvidia quadro 4000 opencl 1.1 cuda 6.5.20 full_profile used original nvidia sdk bitonicsort.cl i used"ulong" keys , value input , ouput instead of "uint" thanks helping i made work-around suit need. used 30 bits of key , 18 high bits of value sorting. changed comparators (2 lines): '#define mask 0xffffc000 // suit need from this: if( (*keya > *keyb) == dir ) this: if(((*keya > *keyb)||((*keya == *keyb)&&((*vala & mask)> (*valb & mask)))) == dir ) it works fine. but, still, it's work-a
Read more