Error Message Visual Basic 400 - help!

I have attached sample files of what I am running. Please forgive me if my lingo is off but what I am trying to accomplish is I have an Excel template of a packing slip called Factory Master Packing Slip and it has an Import button. Once the import button is press it brings up a Import File box. You then select the file to import.. and this case it will be the Shipping Slip 2 file attached. It should take the data from form 1 to form 2. I have run this macro on other forms with luck but not with this one. Can the pros take a look at this and tell me what i am doing wrong. Maybe a setting?

Should state that I am getting the "400" error when running...

Hello EarlD,

I partially rewrote your macro and tested it. This will copy the information over from the imported workbook to the template.

Please Login or Register  to view this content.

Leith,

Here are the errors I get when using your code. Please see attachment. I really appreciate all your help.

Earl

Keyur,

I get the same error on your solution. It must be something I just am over looking. I attached the updated file in case you see something I don't. Thank You

Hello EarlD,

Here are you original files with the macro I added.

Hello EarlD,

If you read the comments I inserted into your code, you will find the section that deletes all the macro code from the workbook. It appears you weren't aware that this section of code did that. You can simply delete that section and all the macro code will remain intact. When you copy code, if there is part of it you don't understand then ask someone to explain it.

Delete these line from the macro

Please Login or Register  to view this content.