export new WBK with CSV file

[adeel1]

Hello all
Column I, Q, M will be static with mention data other will copy from sample file!
My most concern is about data in column A & B, where I received data with different strings/spelling which I need to correct manually I made max. examples please review
Column A has some of has dashes, leading and trailing spaces (these are char spaces)
Column A data will copy with leading “0” & make text column in exported file.
I want to export with CSV file and save at C:\Users\Pervaiz Iqbal\Desktop\AA\
WB name always will A2 of original file and WS name will “grvConnections”

Please be flux in code to fill remaining of data myself!
Thnx in advance

Adeel

[Pepe Le Mokko]

I suppose WB is "workbook" not Warner Brothers?
( AFAIK the abbreviation is usually "wbk")

[adeel1]

My apology, i didnot aware to it you are correct it's workbook.

Adeel

[Pepe Le Mokko]

Change it in your thread title then to help our members understand. Thx

[adeel1]

I have updated!

[adeel1]

Can anyone help please!!

[adeel1]

any one please

[jindon]

Not really sure...

Please Login or Register  to view this content.

[adeel1]

Hi Jindon
thnx for you reply & help, the file with the name "04311234560" is resulted file in my first thread, above code is exporting wbk with same sheet, in resulted("04311234560") sheet header and sequence are different(please ignore header of sam file),please review and follow "04311234560" file & your above code is working fine for column A,

Adeel

[jindon]

Please Login or Register  to view this content.

[adeel1]

hi
thnx sir, its works well with little issue, apology for not well defined as my language isn't English.

you have fix all the data actually it will not, fix data only will for column i, Q & M, all other data will copy from sam file likewise sam file column A copy to column B of new WBk, column B will go to column N, column C will go to column W, column D will go to column R, column E will go to column K, column F will go to column O.
if any of blank that will not fill.
Adeel

[jindon]

Wait for someone else who can understand what you are trying to do.

[adeel1]

hi sir
i made example for better understanding, your code is working fine only issue is data placement in exported sheet, please review yellow highlighted columns with comments,
actually i only made sample data in sam file, data will vary and change as per need, please review

Adeel