Hi Luis
Good that you're online and thanks for your response.
I think there's some movement in our quest.
I have ran your code (after adapting it to my situation, like servername, and used it.
This worked for 3 times, now no more files are added in the directory SQL ServerResults, no matter how often I run the procedure.
Maybe a question
I now have 2 stored procedures
Should I not call the procedure [spTryOutCreateFile] from [spTryOut] so that it can save the results from spTryOut
In Excel's VBA I can call a function to work with the results from a sub
2nd: I don't understand the phrase "TEST.dbo.spTryOut" Where does this TEST. come from?
Thanks Hein