Macro to update excel document with data from another excel document

[lyndadodd]

Hello, everyone.
I am new to VBA and trying to automate some of the tasks that my fellow coworkers have to do. Currently, I need to load data into a excel worksheet with data retrieved from another. I think I am close but at my wits end. I'm sure the problem is some small thing I am missing. Here is how I want it to work - the user opens up a workbook form and will press F8 to execute the macro. The user will then choose the excel document with the data they want to load. All that is working fine - I just don't get any value back. Currently, I am currently just trying to get the value for one cell back. I'll add others after the macro is working. Below is my code. I'm sure it is not pretty to you experienced coders. Thank you in advance for your help.

Please Login or Register  to view this content.

Lynda

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[lyndadodd]

I apologize. I will do that in the future. Thanks for your help.

Lynda