open multiple file text and insert the data to sql server

Hello, I have a case here,

I want to open multiple text (TXT) files using vba macros, then smoothed the data first before being transferred to sql server, here's my code to open multiple file, but i still have problem in looping process..

Sheets("Branch_Process").Select
For i = 7 To 9
varCellValue = range("H" & i).Value
fileName = "C:\Users\SIMAS-FUJ1\Documents\DataTextfile\" & varCellValue

Workbooks.Open (fileName)
Next i

the problem is, it's only open the first file and i got a messagebox "file C:\Users\SIMAS-FUJ1\Documents\DataTextfile\." cant find or maybe delete.

thankyou..

FYI : cell value in H7 until H9 is the name of the file txt,, example : ASR_ID0010183_CRF.BLSHEET1.SUMMARY_20151231.txt, etc

Originally Posted by NeedForExcel

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

i already attached workbook and 2 sample data txt.
there is 204 files that need to open and do something to clean the data first, and then export to sql server before return to do same process with another data until 204 files.. for example, looping with 2 data sample. but the problem is that it said the second file is not detected/removed,, when i test without looping, open each file is succeed.

if someone have the same problem like mine, pls help.. i really appreciate,, thankyou