Return value of named constant without opening workbook

[stefankemp]

I am importing data from multiple workbooks in a folder using ADO. But I only want to connect to workbooks where the value of a named constant within each workbook, "isTemplate", is True. Is there a way to check this value without opening the workbook? Perhaps via ADO? Or alternatively to simply check for the existence of the name?

 

[Firefly2012]

I think you can use an XLM4 macro constant for this (or write a suitable formula to a worksheet cell and check the results). Let me see if I can remember the relevant post...

 

[Firefly2012]

It seems you can't use the ExecuteExcel4Macro approach I thought might work (unless the named constant is a single cell range - then it could/should work).

And it seems you can't refer to a named constant in another (closed) workbook either (so I was wrong on both counts).

 

[energman58]

I came across this a while ago intending to use it but I have never used it - it may help you

http://numbermonger.com/2012/02/11/...g-dynamic-links-to-closed-workbooks/#comments

 

[stefankemp]

Thanks. I ended up putting a value in a cell in a hidden sheet for each workbook that needs to be imported, and using ExecuteExcel4Macro to check its value.