How do you set the "global delimiter" in Excel using VBA?

Question

I've noticed that if I use the text-to-columns feature with comma as the delimiter, any comma-delimited data I paste into Excel after that will be automatically split into columns.

This makes me think Excel must have some kind of global delimiter.

If this is true, how would I set this global delimiter using Excel VBA? Is it possible to do this directly, or do I need to "trick" Excel by doing a text-to-columns on some junk data, then delete the data?

My ultimate goal is to be able to paste in a bunch of data from different files using a macro, and have Excel automatically split it into columns according to the delimiter I set.

Answer 1

Junk data is the right answer. See here

http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters