Import data from multiple files
Jacob,
Looks brill. Thanks
Dean
"Jacob Skaria" wrote:
Daear Dean
The below code should do.......
Dim strFolder, strFile
strFolder = "C:\"
strFile = Dir(strFolder & "*.csv", vbNormal)
Do While strFile < ""
'Write your import code here
strFile = Dir
Loop
If this post helps click Yes
---------------
Jacob Skaria
|