Xtreme Visual Basic Talk

Xtreme Visual Basic Talk (http://www.xtremevbtalk.com/)
-   .NET File I/O and Registry (http://www.xtremevbtalk.com/-net-file-i-o-and-registry/)
-   -   How to use fileshare in excellibrary? (http://www.xtremevbtalk.com/-net-file-i-o-and-registry/327043-fileshare-excellibrary.html)

python01 05-11-2014 10:07 PM

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?

All times are GMT -6. The time now is 09:44 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Optimisation provided by DragonByte SEO v2.0.15 (Lite) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
All site content is protected by the Digital Millenium Act of 1998. Copyright©2001-2011 MAS Media Inc. and Extreme Visual Basic Forum. All rights reserved.
You may not copy or reproduce any portion of this site without written consent.