• 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.

Consolidation of Multiple Files in to one output file

D

Dinesh_Excel

Member
Hi Friends,

I am getting an error while executing the code.

Input file contains all the files which needs to be consolidated.
Output file contains a single file for the records which will be consolidated.

Have attached the macro file and the screens for error message.

Please help....!
 

Attachments

  • Consolidation macro final.xlsm
    70.1 KB · Views: 3
  • Error Code.JPG
    Error Code.JPG
    51.7 KB · Views: 8
  • Runtime Error.JPG
    Runtime Error.JPG
    32.6 KB · Views: 7
Have You checked what would be value for 'tgtWbk'?
.. please do not try to answer that 'Set tgtWbk = ... and so on!
I mean the real current checked value.
 
You must log in or register to reply here.
Back
Top