Link to home
Start Free TrialLog in
Avatar of sirbounty
sirbountyFlag for United States of America

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.  
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sirbounty

ASKER

I don't quite follow the first step on that second link...the first link appears to be what I've already tried...
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.
"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
Couldn't get this working, so I abandoned the project for now.