Command button macro

I'm having trouble making this macro I wrote run with a command button.
The macro is a demo macro I'm writing for a much larger project, and this is basically what it does:
It allows the user to browse for a pre-formatted file. It then reads the file, stores a few values and plugs it into the designated cells in the workbook the macro is running out of.

The macro itself works when I manually run the macro. However, when I run the macro through the command button, it will execute the first half but not the last half. More specifically, it searches for the file, opens it and makes it the active window, but does not plug in the values in the designated cells.

Please Login or Register  to view this content.

Am I not using the correct format for the command button? or is it something else?

Thanks,

Your macro can be shortened to:

Please Login or Register  to view this content.

No need to store the locations of the values in the other workbook that you are looking for. A couple things I'd ask you:

Are there multiple worksheets in the workbook that is selected? Your code does not deal with sheets, so the active sheet will be where data is taken from.

I hate to ask, but are you sure you are looking for the data in cells A1, B1, C1, and B2?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Here's an alternative

Please Login or Register  to view this content.