On 14 Mar, 03:50, DownThePaint
wrote:
Hi ytayta555;

*Second, have you tried going back and forth
between the workbooks by using the Windows.Workbooks("xxx").Activate method. *

I forget to explain , my sistem is powerless and I must
open and close every workbook before I begin the querry
in it ; I can't open first 10 workbooks , for example ;

Respectfully