So I've been delegated the unenjoyable task of trying to get a Microsoft Excel file to do what one would typically do with Access. It sucks.
In my poking around Excel, I found Microsoft Query buried deep within the menus, which is able to query spreadsheets much like Access would. In fact, it appears that I'm perhaps running a bastardized version of Access from 1992, featuring the new "everything's flat" user interface, which is leaps and bounds better than the ribbon one.
Anyhow, is anyone aware if it's possible to automate Microsoft Query with Excel macros, or is this a pipe dream?
In my poking around Excel, I found Microsoft Query buried deep within the menus, which is able to query spreadsheets much like Access would. In fact, it appears that I'm perhaps running a bastardized version of Access from 1992, featuring the new "everything's flat" user interface, which is leaps and bounds better than the ribbon one.
Anyhow, is anyone aware if it's possible to automate Microsoft Query with Excel macros, or is this a pipe dream?
