• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

code execution interrupted while pulling data from desktop workbook(from each work sheet)

A

Amit Modi

Member
Hello,
Hi am trying to get data from file named”1” in my target file I had written code but does not working.
I had tried this code from your forums in my last query, but I get error “code execution is interrupted”
Please help me to remove this error.
I need data from each sheet of file “1.xlsm”.
Thank you.
 

Attachments

  • target file.xlsm
    512.6 KB · Views: 4
  • 1 data.xlsm
    102.6 KB · Views: 2
sir its working paste all data bur same error "code execution interrupted" is displaying,please do needful if possible
 
Well It is not coming at my end.

Can you debug the code one by one line by going in the code press F8 one at a time and see on what line this error is coming.

Regards,
 
when I press command button a window open havin same error and after clicking debug its directed me in code to line where code have "End If". But by pressing f8 its doesn't show any error except large data amount placed in clip board.
 
thanks sir ji,
now its works perfectly,
Now please help me for same situation when I have more than 10 workbooks in my folder and I need to pull data from each sheet of each workbook,
is this possible sir??
please help me if its possible.
 
In your first code try inserting below line
Code: 
          Application.CutCopyMode = False

after this line
Code: 
          targetsheet.Paste Range("A65536").End(xlUp).Offset(1, 0)

and see if the error comes or not?

Regards,
 
thanks sir ji,
now its works perfectly,
Now please help me for same situation when I have more than 10 workbooks in my folder and I need to pull data from each sheet of each workbook,
is this possible sir??
please help me if its possible.
 
You must log in or register to reply here.
Back
Top