大概的思路就是:
Dim s As string
for each r as row in tables("xxx").Rows
s = s & Filesys.ReadAllText(r("文件列"))
Next