Anne Troy
MrExcel MVP
- Joined
- Feb 18, 2002
- Messages
- 2,632
- Office Version
- 365
- Platform
- Windows
Someone asked me this directly at a tech site that is not a community like this one, where I can ask *everyone* for help. So, if you don't mind, I'll ask it, give him his answer, and then tell him where I got it!
Here is his post; mostly corrected because he states he's from Italy. If I didn't understand what he meant, I didn't correct it:
I had a excel sheet written in Excel 97, which contains a macro that, opens a CSV file with field separator as the ~ character.
Normally, on an Office 97 PC, I modify the international setting so that the list separator is ~ and the CSV file opens corectly.
Now, in Excel 2000, if I open the CSV file with the macro, the application cannot see the ~ separator. I use the woorkbook.open command.
If I try to open the CSV file out of the macro directly from the menu bar, and set the file type to a text file, this converts the file correctly.
I tried to use the Format =6 and specified the delimiter into "~", but it didn't work.
I also tried to use the opentext function, but it didn't work.
THANKS ALL!
Here is his post; mostly corrected because he states he's from Italy. If I didn't understand what he meant, I didn't correct it:
I had a excel sheet written in Excel 97, which contains a macro that, opens a CSV file with field separator as the ~ character.
Normally, on an Office 97 PC, I modify the international setting so that the list separator is ~ and the CSV file opens corectly.
Now, in Excel 2000, if I open the CSV file with the macro, the application cannot see the ~ separator. I use the woorkbook.open command.
If I try to open the CSV file out of the macro directly from the menu bar, and set the file type to a text file, this converts the file correctly.
I tried to use the Format =6 and specified the delimiter into "~", but it didn't work.
I also tried to use the opentext function, but it didn't work.
THANKS ALL!