Data Source

[plans]

Hi,
How could I getthe Data Source Name of the Active Worksheet?
Thank you

[PCI]

How is your data collected ,: Is it a Query, Formula ...
A short Excel sample will help a lot.

[plans]

PCI
I am generating a Data Query by clicking: Data/New Query/From File/From Folder
When the "Folder" window pops up, I navigate to the folder where my Excel files are saved, for example:

C:\Users\ME\Documents\MyExcel Folder

At that point Excel will generate the Data Query.

My question is how can I get the Folder Name "MyExcel Folder" through a VBA code, to be displayed in a Message Box.
Thank you very much