Link to home
Start Free TrialLog in
Avatar of leezac
leezac

asked on

Code Executer has been interrupted error

I am just trying to import an Excel sheet into Excel and am getting an error I have never seen before "Code Executer has been interrupted and stops on Cell.Select.  I am using Excel 2010. I have been getting the error in other files.  Is there a way to bypass it??

Thanks in advance.

Sheets("memory").Activate
    'Import file
    Workbooks.Open Filename:="P:\memory.xls"
    Windows("memory.xls").Activate
    Cells.Select
    Selection.Copy
    Windows("Capacity.xls").Activate
    ActiveWindow.WindowState = xlNormal
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
leezac,

Can you please attached the files? I have been trying your code but cannot recreate the error you are experiencing.
Avatar of leezac
leezac

ASKER

I have never had it happen before..   Can't attach files. and  

Brian,  I need code to run with having to do Ctrl+Break.....
Leezac,

Sorry, I don't understand what you mean. Have you tried the suggested sequence when the message appears?

Regards,
Brian.
Thanks, Leezac.