We've inherited an application with a series of EXCEL worksheets that each contain
dozens (if not hundreds) of canned ODBC d/b queries.
All of which "hard-coded" to refer to an external D/B ...
we need to be able to see the details of the actual queries as they are now in order to alter them for our own use, but are unable to do so
thru excel. The previous owners of this app haven't been helpful in this area.
Is there anyway to read / parse the contents of an EXCEL spreadsheet, so as to extract the various queries ?
They are NOT coded as VB /VBA, already looked there.
Yours,
Mike Genovese
ATI/Marlboro
QE
508-303-3900, xt. 3845 (external)
5-881-3900, xt. 3845 (internal)
