Adjusting this macro that checks if too many workbooks are open to take into consideration the personal workbook etc

[tonywatsonhelp]

Hi Everyone,

OK so i have a macro that runs to copy data from on one open document to another,
it works great but I want a safegauard that checks there are only two workbooks open the one with the macro and the one with the data to be copied
Now i have this code below, and it works great except some of use have our own Personal Workbook that stores macros so the check needs to be if personal is present check for 3 if not 2
any idea how i do this?

heres my code

    If Application.Workbooks.Count > 2 Then
        MsgBox ("Too many documents open.")
        Exit Sub
    End If

 

[Anthony47]

May I suggest that you copy from a named workbook and paste to a second named workbook, rather than checking you have only workbooks(1) and workbooks(2) open?

If you share the code you use to copy and past we will be more specific on how coding that.

Bye