• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • Last Modified:

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.  
0
sirbounty
Asked:
sirbounty
  • 3
  • 3
1 Solution
 
sirbountyAuthor Commented:
I don't quite follow the first step on that second link...the first link appears to be what I've already tried...
0
 
CodeCruiserCommented:
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.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
sirbountyAuthor Commented:
"Open Shared Services from central administration." - where is this?
0
 
CodeCruiserCommented:
You do have access to central administrator of the Sharepoint Server right?

http://technet.microsoft.com/en-us/library/cc263312(office.12).aspx
0
 
sirbountyAuthor Commented:
Couldn't get this working, so I abandoned the project for now.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now