<div>
One reason is that your application crashed or you ended it in debug mode before executing the Workbooks.close &nbsp;.<br />
If that is the problem<br />
goto<br />
Windows Task Manager &gt;&gt;&nbsp;processes tab<br />
find excel.exe<br />
end process
</div>


One reason is that your application crashed or you ended it in debug mode before executing the Workbooks.close  .
If that is the problem
goto
Windows Task Manager >> processes tab
find excel.exe
end process

<div>
<div class="content wysiwyg-content">
I have been programming a little VB referencing the excel library. I open the file using the workbooks.open command. Then i close it with workbooks.close command. however, after running this code, whenever i try to open the &quot;1.csv&quot; file now, it says that it is locked for editing, by 'another user'. what's going on?<br />
<br />
<br />
sub main()<br />
<br />
Workbooks.Open FileName:=&quot;C:\Documents and Settings\Jason\My Documents\1.csv&quot;<br />
<br />
a = Range(&quot;b8&quot;)<br />
MsgBox (a)<br />
Workbooks.Close<br />
end sub<br />

</div>
</div>


I have been programming a little VB referencing the excel library. I open the file using the workbooks.open command. Then i close it with workbooks.close command. however, after running this code, whenever i try to open the "1.csv" file now, it says that it is locked for editing, by 'another user'. what's going on?


sub main()

Workbooks.Open FileName:="C:\Documents and Settings\Jason\My Documents\1.csv"

a = Range("b8")
MsgBox (a)
Workbooks.Close
end sub


Phantom person using excel file

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.