Error 1004 *cannot spot any problem*

**alicelia** · 05-20-2015, 02:10 AM

Hi everyone, I am not very familiar with VBA and I used the code below to import data from one workbook to another.
The data does import to the selected cells but if I click cancel after the file directory comes out, I get the 1004 error and its saying the underlined line is wrong. Also, the file opened for data import asks if I would like to save the changes after it is opened. Is there a way to make it go away too? Please let me know how I can fix this. Thank you very much!

Please Login or Register  to view this content.

**alicelia** · 05-20-2015, 05:05 AM

Thanks for the reminder. I have since added the code tags.

**alicelia** · 05-20-2015, 12:17 PM

Excel experts please do help. This is for my school's marksheets. Thanks.

**alicelia** · 05-28-2015, 04:27 AM

ANSWER: ADD "on error resume next"

Error 1004 cannot spot any problem

LinkBack

Thread Tools

Rate This Thread

Display