Sleeper: Extract file using vba macro

[zieylar]

Hi. I really need help in extracting a file (.txt) then convert it into excel using vba macro. Can anyone help me? Thanks.

[Jacob Hilderbrand]

You can just open the file and follow the instructions to specify the delimiter for your data.

Can you be more specific with what you want to do? Maybe attach a file.

You can also record a macro and open the file manually, then check the code.

[Bob Phillips]

Try going through the steps with the macro recorder on, you will have most of the code then.