Macro does not work in Userform

I have created a Macro which pulls excel files from a folder and pastes them into a Sheet in my workbook.
I then created a user form which runs this macro.

The Userform works perfectly on my computer.

I then shared the excel file with other people to use.

I changed the folder path for their specific computer.

I run the macro without the user form and it works great.

BUT

When i run the macro through the userform it is not working Properly.

He is the code, and thanks in advance!!

Please Login or Register  to view this content.

Hi jeck,

Without a full study of your code this sounds like a Scope problem. See if cpearson can explain it better at:

http://www.cpearson.com/excel/Scope.aspx