sirbounty
asked on
Reading a single excel file from sharepoint
I'm looking for a method (vbscript, powershell, vb.net) to read from a single excel spreadsheet located on share point.
I've tried some examples online, but can't seem to get past the 401 - unauthorized error.
I've tried some examples online, but can't seem to get past the 401 - unauthorized error.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You mean the following bit?
"Copy path of document library and add the path into trusted location to enable excel services."
There are step by step instructions on doing that.
"Copy path of document library and add the path into trusted location to enable excel services."
There are step by step instructions on doing that.
ASKER
"Open Shared Services from central administration." - where is this?
You do have access to central administrator of the Sharepoint Server right?
http://technet.microsoft.com/en-us/library/cc263312(office.12).aspx
http://technet.microsoft.com/en-us/library/cc263312(office.12).aspx
ASKER
Couldn't get this working, so I abandoned the project for now.
ASKER