Problem importing text file using macro

[welchs101]

All:

I created a vb macro to open a text file then process the file then close the file. Here is my problem:

Problem: The text file has rows of data in it as follows

5155111111551511111111111511111111111111111

This row of text gets converted to an exponential such as the following:

5.16E+42

because excel treats the row of text as a number but i dont want it to do this transition.

When i save the file and then reopen it using say NOTEPAD i see 5.16E+42 and not the long string of text.

Is there a solution to this?

Any help would be appreciated.


David

[mrice]

Can you expand further, please, on what sort of processing Excel is being asked to do by the macro. A code snippet would be useful.

[welchs101]

Here is a code snipet of opening the file.

Please Login or Register  to view this content.

After i open the file i convert all "N" to "." then save and close the file.

[VBA Noob]

welchs101 or is it DHolcombe

Please read forum rules below and then add the link to the cross post on the other forum

VBA Noob

[welchs101]

Sorry about the cross forum violation.

Wont happen again.

But did want to let everyone know that Norie solved my problem.

The 3rd dialog box on the import text dialog box make sure to check text and everything works great.

Thanks again.

David