Export to CSV with a Variable Amount of Columns

[jabce85]

I have been searching for quite a while now for an answer to this problem with no success. This forum seems like the best place to find an answer. I'm looking for a macro to take the following input and export it to a csv file to look like what I have listed.

INPUT-----

5 5 5 5 5 5 5
5 5 5 5
5 5 5 5 5 5
5 5 5 5 5 5 5 5 5 5
5 5 5

CSV OUTPUT-------

5,5,5,5,5,5,5,
5,5,5,5,
5,5,5,5,5,5,
5,5,5,5,5,5,5,5,5,5,
5,5,5,

If at all possible, I need it to be able to keep the formating that is in the excel file when it exports to the CSV file as well.

 

[Weaver]

So some of the cells in question have formulas? What would you expect to see in the csv in this instance?

I've tried incorporating formulas that produce results and those that don't and so far I'm achieving the results I'd expect.

Not sure how I can take this any further on what you're telling me.

 

[jabce85]

Alright, thanks a lot! I got it to work with just a minor bit of tinkering.

 

[Weaver]

What did you do?

 

[jabce85]

Sorry for the delay.. I had to modify it slightly to get it to work with all the other code I had; I wasn't just exporting to csv; the comma problem was my only stumbling block. Thanks once again!

 

[Weaver]

No worries.