Reading from a closed workbook

W

WannaBeExceller

I was wondering if there is a way to read from different excell workbooks
that are closed. I am trying to read data from different workbooks do some
calculations and then store the values in my current workbook that is open.
If I open all the workbooks, I run out of memory. I figured the way around it
is to read the files while they are closed. Please help. Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Password protect new workbooks from template 0
populate a combobox based on unique values in another workbook 16
Ignoring a runtime error 1
closing another file by code causes failure to run workbook activate event 2
Custom Document Properties in Word documents and Excel workbooks 15
OpenDatabase recommended practise 0
Opening a list of Excel files and run a macro in each 17

Top