First, let me say - I'm new to Excel / VBA programming. I have developed
VB.net apps, however the environment in Excel is a little different. OK now
I don't feel so dumb. I am in the process of converting a MS Access App to a
SQL Server backend. There is an Excel spreadsheet that I KNOW accesses MS
Access. There is a macro that does the following -
Range("A2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False

How does Excel know what the data source is - it does b/c it says not found
so it must be in some nook somewhere. Can someone give me a little
assistance here?? I just want to know what query is being called.

Also, Part II - this spreadsheet has about 12 worksheets with many columns
that 'seem to be' mapped to columns from the data source - but I can't see
where the mapping is taking place. HELP!!