Thread: File Open Check
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dthmtlgod dthmtlgod is offline
external usenet poster
 
Posts: 1
Default File Open Check

I have an Excel spreadsheet that exports its date to Access when all my
macros are done running. It errors out if the database/file is open.

Is there a way to check to see if the datebase/file is open before I try to
export?