Get value from closed workbook Excel 2010

**Karolis** · 12-14-2011, 04:43 AM

Hello,

I was using this code to get value from closed workbook in excel 2003. Now my company upgraded to office 2010 and it is not working any more. Is there a way to adjust the code to suit new software or replace with some other commands? I also tried MoreFunctions add-on to use better INDIRECT formula, but it seems it doesn't work with 2010 excel as well. Thanks you for you help in advance. Here is my code:

Please Login or Register  to view this content.

Any suggestions with this issue? Is it possible or maybe not?

**Karolis** · 12-15-2011, 05:40 AM

I also tried to use INDIRECT function in cells and use VBA to open files I require to get the values, but they disappear after code finishes. Then tried to copy and paste values after opening all workbooks required and close them, but ran into a problem with opening all files in sub directories. Maybe any suggestions here?

Code I was using:

Please Login or Register  to view this content.

**Karolis** · 12-21-2011, 10:23 AM

Bump. Any thoghts anyone?

**Sheron** · 08-22-2012, 03:09 PM

I'm looking for this same information. Did you ever get this to work?
Thanks!!

**arlu1201** · 08-23-2012, 02:36 AM

Sheron,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.