View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Art Art is offline
external usenet poster
 
Posts: 587
Default Opening linked spreadsheet file in Access

How do I test for an Excel file being available (not open by a user) in
Access VBA? My code opens a series of Excel files, one at a time, but when I
encounter a file already open/in use, I need to be able to trap it.
Currently I get a runtime error and have to quit.
--
Art