I found this thread: http://community.qlik.com/thread/3915
Have you tried Readfile(File) ?
edit: something else you can try is creating a function that first loops through all the files and renames any file that contains a ', so you are sure that afterwards all files will load without problems.
Try replacing the single quote with a double quote in the load script and put it into a variable submit to function ...
For each File in FileList ('*.csv')
newFile = Replace(File,chr(39),chr(34)) // replace ' with "
let x = ReadFile();
let x = ReadFile(newFile);
... then recover the variable value in the macro and change the characters back ...
Function ReadFile() ReadFile(newFile)
strFile = ActiveDocument.Variables("newFile").GetContent
ReadFile = Replace(strFile.String,chr(34),chr(39))
Message was edited by: flipside Corrected method, variables obviously not available during load