Error opening text file due to encoding issue.

not sure what you mean...........


also, new information: i tried the code below and i got something interesting:
the first characters in the first row are a y with two dots over the "y" and then what looks like a "p" but is not really a p

Please Login or Register  to view this content.

i tried vbnewline as you suggested....it gave same results as the case where i used vbCrLf

Hi,

seems not to be a very interesting problem but a lack of file structure knowledge like in your still opened thread …

Join a source csv file and this time a workbook with a desired result worksheet !

here is a screen shot of what "txt" and "x" look like

marc, if new how to do what your saying i would......but i dont.........i really wish i did though

buran, what do you think i should try to figure it out?

just tried both and neither worked.

ok....i have repeated this twice to make sure it works so here it is.......

i open the file in question using EXCEL. I then save it as a "Text(Tab delimited)" file type and then run using my macro and IT WORKS!

However, if i open the same file using notepad and save it it does NOT work....i get the weird characters i mentioned before in the image i sent out in another post.........could this be an "encoding" issue

ok...i was able to MAKE an input file which has the same problem as my original file............enclosed is the input file.

does this help identify the problem?

This seems like an encoding issue to me. It's actually moderately similar to the thread I just started. My guess would be that Excel is interpreting the file saved by Notepad as some encoding type which doesn't actually fit. I'm not sure if there's a way to force Excel to open a file with different encoding, but if so, that might solve it. (Ironically, I didn't actually see you mention encoding before typing all that out.)

well thanks for trying.......

can someone help? anyone? i have been at this all day trying to figure this out and i have no idea how to solve it.......

my two main questions are
1. why does notepad not show the supposed special characters
2. why does the code not read it in properly. the code works i know that when i open the input file and actually save it from excel as a Text(tab delimited file).

buran, did you see the special characters in the input file i sent when you run my code?

Nevermind...

I got error #62 with the joined file, like it's corrupted …

figured out problem and someone found soln for me


it was the encoding!!!!!!! that was causing the problem. My original input file was enclosed as "UCS-2 Little Endian". However, when i imported the file into excel and then saved it as a "Text(tab delimited)" file my program worked the encoding of this file was "ANSI as UTF-8". So the ansi utf-8 worked but the other did not........

in my code i was using the following to open the file.

Please Login or Register  to view this content.

a friend looked it up at this location

HTML Code: 

and from this i changed my code to the following

Please Login or Register  to view this content.

and it worked!!!!!!!!!!!!!!!!!!!!!!!!!! no special characters found..............

Alright, I managed to get it working (to the point that I can see your problem, not to the point of solving it, sorry). I do see the messed up characters. Not sure what's causing it yet. Anyway, open a new spreadsheet, attach this subroutine, modify it so it points to the file (from this post), and then run it. The first cell ends up with "ÿþTrigger Name".

Please Login or Register  to view this content.

EDIT: Oh, good

The method is documented in the VBA inner help …

marc, what method are you referring to.........if you can forward a link that would be great.

i still wonder why notepad does not show the "extra characters" associated with the encoding......what is encoding anyway.

also, and maybe this should be a new thread........but is there a way to identify what type of encoding a text file has so that if it has different types i could select different formats in the fileopen command so that it gets read in correctly?

i think i pasted the wrong html link from before below is the opentextfile link

HTML Code: 

so interesting result and again fuels my desire to determine encoding of text file.........

recall that my original code statement

Please Login or Register  to view this content.

and in this code the format is "-2 = TristateUseDefault" works with those files saved from excel as Text(Tab delimited)

and the new code

Please Login or Register  to view this content.

and in this code above the format is set to "-1 = TristateTrue"........using the "-1" will not open a text file correctly if this text file was created from excel saved as Text(Tab delimited).


so if i get a file like i am supposed to then i should use the "-1" however, if for some reason i get a different type of file then my code wont work.

No link needed 'cause method is already in VBA inner help …

Notepad doesn't show that special characters 'cause they are the encoding code and its detects it …

thanks xander i will check out the page

xander just an fyi........i tried running the code provided in that link you sent and it did not run........i am thinking this code may not work for excel vba.......

apprarently it program, when i try to run it, stops at this step

Please Login or Register  to view this content.

i am not sure what ADODM.Stream is but my guess is that is not compatible with excel vba.

got program to run but not sure its running correctly..........i changed some code to this

Please Login or Register  to view this content.

but it does not seem to output anything useful

does anyone know how to edit the title........i was thinking this title does not really go with the thread.....but i did not know that when i first started it but now i do and i was thinking of changing the title