Query Workbook in Sharepoint

[SkipVought]

In the world outside of SharePoint, I can use MS Query, via Data > Get External Data... to query data either in the active workbook. However the only PATH available, seems to be OUTSIDE of SharePoint rather than the path to the workbook in SharePoint which is something like...
[tt]

http://portal.bh.server.com/sites/it/euis/fp/EIM

Report Needs
[/tt]
Is this possible in the SharePoint world?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[ehaze]

What Office app are your trying to query from?

http://www.sharepointed.com/

 

[SkipVought]

"...query data either in the active workbook..."

I am IN Excel, querying a sheet WITHIN the workbook. Do it often, outside the SharePoint workd.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[ehaze]

Have you tried grabbing the UNC path?

Open the Document Library in Explorer View.

http://www.sharepointed.com/

 

[SkipVought]

Here's the deal. I have many workbooks on the network that interactively grab data, via queries of various types, many of which grab data from other internal sheets in the workbook, and perform analysis and reporting in VBA. It's a black box to the user: they open a workbook and operate some controls and stuff happens.

I've done some research and found an 'overveiw of connecting (importing) data - Excel - Office.com' In it is shows Excel data object and data source support that creates an External Data Range for SharePoint List...
[tt]
Excel Tables
Data Connection Widard
[/tt]
But I have not discovered a way to implement as yet WITHIN SharePoint in Excel, as each method seems to only have \\\ paths rather than /// paths.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[ehaze]

Open a Library in Explorer view.
Right click on a document, then select Properties.

What do you see in Location:?

http://www.sharepointed.com/

 

[SkipVought]

Properties in:
[tt]
Windows Explorer
(FILE NAME)
IndInvDashboard.xlsm
LOCATION
\\bhdfwfp426\m_ctr$\1_Supply Chain\SkipM

SharePoint
ADDRESS

http://portal.bh.textron.com/sites/it/euis/fp/EIM Report Needs/IndInvDashboard.xlsm

[/tt]




Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[ehaze]

I got it to work.

Created a new spreadsheet.
Created two columns and populated them with a few values.
Selected the data, right clicks and selected Define Name...
Saved spreadsheet.
Moved the spreadsheet to my SharePoint library.
Mapped a Drive to the SharePoint library.
Opened Excel, from the Data tab selected From Other Sources, then selected From Microsoft Query.
Selected my newly mapped drive.
Then selected my uploaded spreadsheet.
Selected my defined Range.

*not sure if you need to map the drive or not, but it worked.*
*i'm using Office 2010.*

http://www.sharepointed.com/

 

[SkipVought]

Thank you, I will try this as soon as I am able. Stand by!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]