macro ignoring commands

[Directlinq]

Hi i dont know if anyone can help me? (By the way i have two worksheets open before running this macro)
This script works great, except at the bottom at

Please Login or Register  to view this content.

The window "b16" Invoice.xls closes one of the worksheets, but the 2 other commands are ignored. I would like them to run on the other open worksheet.

I have tried the above in a seperate macro and it works but when run after this script it does not. I have also tried time delays but that does not help either.

Any help would be really appreciated

Please Login or Register  to view this content.

Many Thanks

[starryknight64]

Perhaps try and select the open workbook prior to selecting worksheet 1?

Please Login or Register  to view this content.

Another possibility could be to close the other workbook after the two commands needing to be executed have been executed.

Please Login or Register  to view this content.

[shg]

If the window you're closing is the one the code is running in ...

And why use Windows(...) rather than Workbooks(...)?