Please provide your code and we can assist in fixing it.

Barb Reinhardt


"Neon520" wrote:

Hi Everyone,

Thanks to Joel, I have a code to open All Files in one folder to extract the
data from.

However, Debugging Error will occur if any of the file in That folder remain
open, regardless of any changes made and/or user save the changes or not.
Is there a way to code so that there will an ERROR MESSAGE BOX appear when
any of the file in That folder is open. Then the user can click ok and then
close the file manually.

I know there must be a way to force save the opened file and proceed with
whatever is next, but this way might force save any unintended changes save
to it. So I rather prefer it to be manual instead.

Thanks for any help.

Neon520