Need help to access value in another workbook

Albert · Mar 27th 2003

Hi all,

Besides using the link syntax that links the value of another Excel onto the current Workbook : i.e.
=[ABC.xls]Sheet1!A1

I would like to do some manipulation in my VBA code before I put the value into a cell. Can I access a cell in another workbook without actually opening the file in VBA code?

Thx.

Richie(UK) · Mar 27th 2003

Hi Albert,

Try Dave's code here:
http://www.ozgrid.com/vba/extractfromclosedworkbook.htm

Alternatively, just open the workbook, do your stuff, and close it again. With screenupdating off you probably won't notice

HTH

yjoshi · Mar 27th 2003

Try this!!!

http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm

Need help to access value in another workbook

Participate now!

Share