View Single Post
Old 05-11-2014, 10:07 PM
python01 python01 is offline
Join Date: Jun 2008
Posts: 22
Default How to use fileshare in excellibrary?

I am using excellibrary to process excel files. Right now to open the file I am using

ef = Workbook.Load(file)

But if that file is opened somewhere else in another application when I try to access it I get the message:

The process cannot access the file '\OFFICE\MyDocumentsWD\VB2010\Projects\Excel File Checker\Excel File Checker\Test1.xls' because it is being used by another process.

I know that when using streamreader you can use fileshare option and I wonder if there is similar option when working with excellibrary? Or is there workaround to accomplish the same?
Reply With Quote