This project has moved and is read-only. For the latest updates, please go here.

How to close Spreadsheets

Apr 23, 2013 at 4:59 PM
Hi all,
I am using to process data from spreadsheets into SQL.
The problem is that when I finish with a particular spreadsheet I can't see how to close it so that I can relocate it to a processed folder.
This results in a file locked error when I try to use it.

I am currently using the spreadsheet = (new IO.Fileopen(filename).openread)

and worksheet=spreadsheet.workbook.worksheets(n) to get to the worksheet(s) I need

I can't see how to close everything when I'm done though

I know it's going to be simple but I am being dim!

Kind Regards