[AccessD] Checking if a file is open

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Mon Feb 9 09:26:16 CST 2004


the easiest  (aaltough not the best) way would be to see what is the
number of the error you are getting, and write code for that error
prompting the user to close excel appl, and exiting the sub

> Hi All,
>
> I am importing data from Excel into Access.  The initial step in this
> process involves copying the data from the excel spreadsheet into a
> temporary copy of itself.  This step fails if the file is open.  Does
> anyone recommend a method that I could use to see if the file is already
>  open (and then notify the user to shut it down?)
>
> TIA
> RyanS
>
>
>
> This e-mail and any attachment are confidential and contain proprietary
> information, some or all of which may be legally privileged.  It is
> intended solely for the use of the individual or entity to which it is
> addressed.  If you are not the intended recipient, please notify the
> author immediately by telephone or by replying to this e-mail, and then
> delete all copies of the e-mail on your system.  If you are not the
> intended recipient, you must not use, disclose, distribute, copy, print
> or rely on this e-mail.
>
> Whilst we have taken reasonable precautions to ensure that this e-mail
> and any attachment has been checked for viruses, we cannot guarantee
> that they are virus free and we cannot accept liability for any damage
> sustained as a result of software viruses.  We would advise that you
> carry out your own virus checks, especially before opening an
> attachment.
>
> The UK firm Ernst & Young LLP is a limited liability partnership
> registered in England and Wales with registered number OC300001 and is a
> member practice of Ernst & Young Global.  A list of members? names is
> available for inspection at 1 More London Place, London, SE1 2AF, the
> firm?s principal place of business and its registered office.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail




More information about the AccessD mailing list