Convert Excel data Into A Semicolon Separated Text List

[gedraxx]

Hello everyone!

I'm new at the Excel macro thing, I am a VBScript dabbler though. I've been trying to adapt various Column and Row to CSV code snippets and its just not working the way I need. I have a feeling it is stopping when it hits a blank placeholder cell. Please help me

I have a spreadsheet used to generate data for a vendor application. I wanted it set up so that when my user clicks Cell A1, then all data from B3 to FG1000 (or wherever the rows stop) is placed in cells A3 through A-whatever in a semicolon-separated values list. The user will then be able to copy/paste the text string into a notepad to create a plain text file. I also need to have any column that is blank remain so, it should show up as ;; in the string.

The adapted code snippet I've been working off is here:

Please Login or Register  to view this content.

Any help is greatly appreciated!

Thanks,

Oscar

[slx]

So you are going left to right then down? And you want to make each cell end in a ;?

[Olly]

Try:

Please Login or Register  to view this content.

[gedraxx]

Try:

Please Login or Register  to view this content.

OllyXLS thank you!! That is almost perfect! The only issue is that I had some custom formatting on a few columns to format dates and add leading zeroes, can we preserve that?

Specifically:

S3, CC3, CD3 on down : Custom Format mmddyyyy
T3 on down : Custom Format "0"#

Thanks again!

Oscar