How to close a csv file?

[barryleajo]

Hi All

I have been experimenting with exporting data to a csv file.

My procedure failed in the middle of an "export".

I now can't export anything because of a "File Already Open " error.

Can anyone tell me how to close an open file please?

I have tried using a differnt file name and closing closing down Excel but still get the same error message.

Also tried running the Close bit of the code below to no avail

Please Login or Register  to view this content.

Any help much appreciated
TIA
barry

OOPS!
Red face time - sorry guys!
My export code utilises a loop and my Open statement was inside the loop.
With apologies
barry