Opening A 2nd Workbook to Retrieve Data From then Closing that Workbook

I am trying to import data from another workbook which requires an indirect function so the workbook must be open. The data is transferred during the IF statement, so I want the other workbook to open before the if statement and the workbook to close after the IF statement, both inside of the For loop. Also, when opening the workbook I want it to automatically say yes to the 2 defaults of Update and Continue (however, I have Application.DisplayAlerts = False and that isn't working). And finally, I don't want to save changes when I close the workbook (I always get an error when trying to active/close the workbook Run-time error 424). Thanks for all the help guys!

Please Login or Register  to view this content.

Could you explain what you mean by reference to the workbook? I'm new to VBA still trying to learn. Also, what do I need to do differently so that is isn't just seeing my path and filename which are combined in one cell as a string?

Everything worked (including closing the workbook) except for the beginning prompt when the workbook opened. It still made me click update, but I didn't have the continue prompt directly afterward. This is the last thing standing in my way!

Please Login or Register  to view this content.