[VBA] Overwrite the semi-colon delimited csv files when exporting the multiple sheets

[dylanrose]

Hi friends!


This problem is related to my old post that was solved already: http://www.excelforum.com/excel-prog...ml#post3788991

Now, my problem is that how can I overwrite the data that was exported in multiple semi-colon delimited files?
What I want to happen is that it won't add any data but it'll overwrite the old data with the new data that'll be exported. May I know how I can do this?

This is the code that I still use (given by Tinbendr),

Please Login or Register  to view this content.

How can I modify this?

Your help is highly appreciated.
Thanks!

[buran]

Hi,

For all of the csv files replace respective code like this:

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

[dylanrose]

Hi,

For all of the csv files replace respective code like this:

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

woah! that's fast.
will try it now.
Thanks!

[buran]

Sorry, but as was quick to answer and I was wrong. My preveous suggestion would end up with csv file with only one row.

Here is your code amended accordingly

Please Login or Register  to view this content.

Note that it's not tested as I was not able to download sample file from preveous thraed

[dylanrose]

Sorry, but as was quick to answer and I was wrong. My preveous suggestion would end up with csv file with only one row.

Here is your code amended accordingly

Please Login or Register  to view this content.

Note that it's not tested as I was not able to download sample file from preveous thraed

woah! that's nice and so fast!
but I have a little problem .. (see attached files):

in photo 1, that is the sample data
in photo 2, that is the sample of the exported file of property type = CD (condo.csv)
in photo 3, that is the sample of the exported file of property type = LA (land.csv)

The problem is that in condo csv file it has the header ie. SUBCATEGORIES DUMMY, categories, offer_type, sku_supplier_source, sku_supplier_config, available_from, etc ... while the land csv file doesn't have.


I attached also the excel file.
Thanks so much!

[buran]

It's because you have this line

Please Login or Register  to view this content.

i.e. it writes header only to condo.csv and it was also like this in your original code. Am I right that you want header in all files?

[dylanrose]

It's because you have this line

Please Login or Register  to view this content.

I see that's also my problem but then I don't know how to modify it further.

i.e. it writes header only to condo.csv and it was also like this in your original code. Am I right that you want header in all files?

Yes, I do want the headers in all files, Buran.
Thank you so much!

[buran]

Here is the code. I rearranged it a bit:

Please Login or Register  to view this content.

[dylanrose]

Here is the code. I rearranged it a bit:

Please Login or Register  to view this content.

wow! that's so fast. thank you so much! my problem is now solved.
Thanks for your time helping me with my excel.

[buran]

great! don't forget to mark thread as [SOLVED]