rsmethurst at UK.EY.COM
rsmethurst at UK.EY.COM
Mon Feb 9 09:28:26 CST 2004
Thanks for the reply Oleg.
That is what I have at the moment, but if at all possible I would like to
work around the file being open, (like I said though - if at all possible)
Cheers
Ryan
<Oleg_123 at xuppa.com>
Sent by: accessd-bounces at databaseadvisors.com
09/02/2004 15:26
Please respond to Access Developers discussion and problem solving
To: <accessd at databaseadvisors.com>
cc:
Subject: Re: [AccessD] Checking if a file is open
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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
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.