Get data from unopened file

The code would be like that

Please Login or Register  to view this content.

This would copy range from closed workbook to the active workbook
Hope it helps you

Hi zico8

Originally Posted by zico8

.....
Is it possible to get data without opening that file?....

Yes and no. You can get the value out of any cell in a closed Workbook. ( without opening it) It is called “performing a reference”
See code here:
http://www.excelforum.com/developmen...ml#post4213824
and here:
http://spreadsheetpage.com/index.php...a_closed_file/
Have a go, and let me know if you need more specific help
Alan

Thanks for it,

but some times ago I was told to apply GetObject:

Please Login or Register  to view this content.

or just:

Please Login or Register  to view this content.

In fact - its works, but can you tell me what is the difference to between GetObject, Workbooks.Open and just Workbook?

Hi zico8,

Originally Posted by zico8

any comments?

I have tried to experiment a little and have looked a lot in Internet for info.

I do not have a complete answer for you. But I can tell you the following
This statement
Dim WB As Workbook
Assigns a variable for holding a Workbook object.

Now to your specific questions
_1) Set WB = Workbooks("myfile.xlsm")
This Sets the WB Object to a specific File, here the opened file "myfile.xlsm". SO THE FILE "myfile.xlsm" MUST ALREADY BE OPEN FOR THIS TO WORK.

_2) Set WB = Workbooks.Open(ThisWorkbook.path & "\myfile.xlsm")
This opens the Workbook "\myfile.xlsm" and sets the WB Object to this file "\myfile.xlsm". So the File must exist but does not have to be open. If it is open this code line will not error

_3) Set WB = GetObject(ThisWorkbook.path & "\myfile.xlsm")
This appears to do the same as _2) , Except the file is not visible. I have not been able to find a way to make this visible. So to manipulate it you must use VBA code. It is good practice to add a line to release the reference to this Object.

Hope that helps a bit.

And here is a code i used to test the above:

Please Login or Register  to view this content.

Alan

P.s. The further code below demonstrate how to do the “Performing a reference”, that is to say it gets data from a closed File without opening that File, as per your original request.

Please Login or Register  to view this content.

EDIT:
To get code line 3) to work as code line 2) , an extra line is required to give in total these two code lines
Set WB = GetObject(ThisWorkbook.path & "\myfile.xlsm")
WB.Windows(1).Visible = True

Thanks to snb
http://www.excelforum.com/the-water-...ml#post4227653
for that one
Alan

and again
http://www.excelforum.com/the-water-...ml#post4228123