Single Column Txt file

[Bob1980]

For some reason, this macro can't import a single column text file. Can someone help me out with this?

Please Login or Register  to view this content.

[AlphaFrog]

The syntax looks correct. What exactly happens?

You can step through each line of code (F8) in the VBA editor.

Does it error? If yes, what's the error?
Does the text file open?
Does it import anything?
What is the text in the text file

[patel45]

this code works, check the sheet name on this line
Set wsData = ActiveWorkbook.Sheets("AASTD Inj 1")

[Bob1980]

Yeah, it's funny cause it works on all of my other txt data.

I get a Run-time error '9', Subscript out of range; on this line:

Please Login or Register  to view this content.

And then the macro creates a new spreadsheet book with the name of the txt file.Here's a sample of the data.

[AlphaFrog]

The equal sign characters ("============") used as a section line separator within the text file is causing the error when you transfer the values to the sheet. Excel interprets a line that begins with an equal sign as a formula.

This will import the text directly to the sheet without having to transfer the values.

Please Login or Register  to view this content.