how to open multiple file text and insert the data to sql server

[lullabbyice]

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