AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
This was found by Googling but it seems not correct.
The line which claims to be Read Only is
However on stepping through the code I find it both Opens the workbook and attempts to run code in it.
So - is it at all possible? It's a large workbook that takes ages to open so it'd be simpler to copy the columns I want to Access and read that.
Thanks.
VBA – Read Data from a closed Excel file without Opening it
I was in a forum recently, when I came across a question on how to get or read data from a closed excel workbook (file) without actually opening it.
www.encodedna.com
The line which claims to be Read Only is
VBA Code:
' OPEN THE SOURCE EXCEL WORKBOOK IN "READ ONLY MODE".
Set src = Workbooks.Open("D:\SMv5.xls", True, True)
So - is it at all possible? It's a large workbook that takes ages to open so it'd be simpler to copy the columns I want to Access and read that.
Thanks.