Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need 2 import *.txt -> XL as pure text - Help w/OpenText ??
Guys: Thanks for the suggestions! I ended up finding a workaround WITHOUT using the OpenText method. Apparently there is some deficiency (bug?) in Excel 97 where if a text file has more than 99 columns, it "freaks out" the import feature when using a MACRO. Somewhere (I don't even...- JetBlack
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Need 2 import *.txt -> XL as pure text - Help w/OpenText ??
I have some fairly long macros designed to handle production of some HTML files, using some csv files I get regularly from a client. Trouble is, I can only seem to get Excel to manage everything properly if I open the files as PURE TEXT ... meaning I have to rename the csv as txt, and then step...- JetBlack
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
