Help importing a non-delimited text file into excel via vba

Greetings all,

This is my first post here as I can't figure out how to accomplish this task. I was given the job of fixing an old employees code that imported a non-delimited text file via vba from a network share drive. Attached below is a small snippet of it for reference. I just want to import the file into a sheet so that it separates the fields so that I can access the data in other sheets via functions. I currently get an error at the .Refresh BackgroundQuery:=False and have no idea what is causing the issue. If anyone can give me the proper way to import the file so that it is usable I would greatly appreciate it!

TEXT FILE EXAMPLE:

Please Login or Register  to view this content.

MY CODE:

Please Login or Register  to view this content.

Hello mlindsay1990,

Here is the description of the Refresh method for a QueryTable object:

Used only with QueryTables that are based on the results of a SQL query. True to return control to the procedure as soon as a database connection is made and the query is submitted. The QueryTable is updated in the background. False to return control to the procedure only after all data has been fetched to the worksheet. If this argument isn't specified, the setting of the BackgroundQuery property determines the query mode.

Remove Refresh from your code because you are not using SQL.

Please Login or Register  to view this content.