![]() Our free service enables you to unprotect Microsoft Excel files locked for editing. ![]() OpenFileDialog1.Dispose() 'Doesn't seem to release the fileĮxcel. Click Unlock File and youre done About Our Free Service. ![]() Here's my code: Using excel = New ExcelPackage(OpenFileDialog1.OpenFile)ĭim ws = () Download the unlocked files instantly or send a download link to. I tried using Dispose() and wrapping my code in a Using block which I thought destroyed everything automatically but no luck. I'm guessing there should be some sort of Close() method or something that will release the resources but I can't figure out exactly what I need. Facility Schedule-Staff visits 1-8-05.xls is locked for editing by Margie (thats me). If I close the application completely, the file is unlocked so I'm assuming the application is just holding onto the file for longer than it should. All of this works as expected with one caveat.Īfter the application is done processing, the file remains locked for editing so when I open the file to make changes, I get this message: The user clicks a "Process" button and the application goes through the file - an Excel spreadsheet - and processes the data in it. I have a Windows Forms application with an OpenFileDialog. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |