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

Browse a file and copy data in Macro enabled sheet

A

amit_gupta123

Member
Hii

I have a data in excel file which changes on daily Basis. I have to format the same manually. For this I have written a simple code. But my problem is on daily basis i have to open the source file and then copy the data from source to macro enabled sheet and then run the macro and copy the output to new sheet.

Is there any way that via My macro enabled sheet i can browse my source file and on selecting the data get pasted in macro enabled sheet and out get copied into new sheet.

Please help

Regards
 
Did you mean you need to copy a macro in sheet module from closed workbook. Can you attach your sample workbook?
 
You must log in or register to reply here.
Back
Top