Random colon delimitation help - Remove colon delimiter?

I seem to be having a random but frustrating problem with one of my macros. My macro simply opens a .txt file in a new sheet with comma and space delimitation. The problem is that I don't have any sort of colon delimiter code in my code, but when importing the data it sometimes decides it needs to treat the colons in my .txt file as a delimiter (Example: Each line of .txt file has a time stamp of HH:MM:SS that should all be in one cell, but it splits it into 3 cells). I do not understand why this is and cannot have this as other code depends on the location of cells within the sheet when the colons are not delimited.

Here is the code I am using.

Please Login or Register  to view this content.

BTW the timestamp is suppose to be in the second column, which I have set to text format if that matters. (Columns should go Date, Timestamp, AM/PM, Data, Data, Data......)

Anybody have any ideas on why this is happening?

Is there any .TextFileColonDelimeter type function I can set to = False? (I can't find such thing)

I noticed if you did want a colon delimiter the code is .TextFileOtherDelimiter = ":"... would something like .TextFileOtherDelimiter = "NULL" be beneficial in anyway?

I am stumped...

Thanks in advance!

Eric

Eric

Do you ever do any data parsing using the colon? If so, then it may be a hangover from a previous parsing in that instance of Excel. You may have to fully with something like

Please Login or Register  to view this content.

rylo

Actually I am. I have another macro in the same workbook that opens up a .cfg file I have that is colon delimited. I will try that line of code to see if it makes a difference.

Thanks!