ExcelBanter - Access values from another workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Access values from another workbook (https://www.excelbanter.com/excel-programming/286473-access-values-another-workbook.html)

Grey

Access values from another workbook

Dear all

can a VBA procedure access a range values in a workbook that is not open?

Million Thanks

Eric

No Name

Access values from another workbook

Hi Eric

maybe this helps

http://www.erlandsendata.no/english/index.php?
d=envbawbreadfromclosedwb

Best regards

Wolf

-----Original Message-----
Dear all

can a VBA procedure access a range values in a workbook
that is not open?

Million Thanks

Eric

Harlan Grove[_5_]

Access values from another workbook

"Grey" wrote...
This is a multi-part message in MIME format.

First, figure out how to post in PLAIN TEXT.

can a VBA procedure access a range values in a workbook that is not =
open?

Yes. See

http://j-walk.com/ss/excel/tips/tip82.htm

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.

All times are GMT +1. The time now is 12:31 AM.