Have Access test for open Excel file

[irishtyke]

Can anyone please help me with a little VBA?

All I want to do is perform a test within Access to see if a specific Excel file is open, and if so, to close it.

 

[WayneRyan]

IrishTyke,

This link should help:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=625

Wayne

 

[irishtyke]

Hi Wayne,

That is absolutely perfect.

I've been trawling the net for days for such a solution.

Many thanks.