excel VBA: “=” delimiter not functioning upon import
I have a .qtx file type with comma, tab and “=” delimiters. An example string of data is “STD_Gloss=4.08”. I want to separate the 4.08 into its own cell, hence the “=” delimiter.
Why does custom delimiter (“=”) not work based on this code?
I had a code working that would open a file type and delimit it appropriately where an = sign was used as the custom (Other) delimiter. When I tried it today, the files will be imported and saved, but not delimited at the = signs.