Access reading Excel Comment

[AlexanderBB]

I have a routine in Access that uses ADODB to connect and read Excel cells.
But I cannot see how to read a comment (Note). Is it possible?

 

[Micron]

it looks like it has to be closed first.

You would test first if it's open.
I recently skimmed over threads that dealt with the ActiveX prompt but wasn't really interested since I wasn't looking for a solution to a problem not at hand. Perhaps it is possible to suppress it. The solution might have been an Options setting. If your wb is already open, I imagine that issue has been taken care of already, so an option might be to just use Access to open wb but not hidden, then deal with the prompt, then return to Access to continue the code. I think that would have to be a 2nd manual operation - maybe just as simple as clicking an Access message box "Click OK when ActiveX message has been deal with in Excel".

As for your last idea, the approach would still be the same: Automation, but this time from Excel.
HTH

EDIT - forgot to mention that Access wasn't hanging up, it was a prompt like the one you're describing, but for saving the wb. Couldn't see it bc wb was hidden. Or did I mention that?