<div>
Have a look here:<br />
<a href="http://www.mvps.org/access/api/api0007.htm" rel="ugc">http://www.mvps.org/access/api/api0007.htm</a>
</div>


Have a look here:
http://www.mvps.org/access/api/api0007.htm [http://www.mvps.org/access/api/api0007.htm]

<div>
Hi D'Al,<br />
<br />
Thanks! Your code did exactly what I needed.<br />
<br />
shanesuebsahakarn,<br />
<br />
Thanks for the reply as well! 
</div>


Hi D'Al,

Thanks! Your code did exactly what I needed.

shanesuebsahakarn,

Thanks for the reply as well!

<div>
<div class="content wysiwyg-content">
Hi Experts!<br />
<br />
I have an access program that creates an excel file to log in any errors I have encountered while the program is running (I don't really open the excel file such that it shows in the taskbar). My question is how can I check if the excel file is open (active)? (Meaning it is open and it's in my taskbar) I want to be able to check if it's open and then be able to close the excel file to ensure that I won't get any errors while I use my program. I always end up with something going wrong in the program when the excel file I use is open. Hope I made sense.<br />
<br />
Thanks in advance!<br />
<br />
rusco
</div>
</div>


Hi Experts!

I have an access program that creates an excel file to log in any errors I have encountered while the program is running (I don't really open the excel file such that it shows in the taskbar). My question is how can I check if the excel file is open (active)? (Meaning it is open and it's in my taskbar) I want to be able to check if it's open and then be able to close the excel file to ensure that I won't get any errors while I use my program. I always end up with something going wrong in the program when the excel file I use is open. Hope I made sense.

Thanks in advance!

rusco

VBA: Checking and closing an Excel file from Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.