Solved

Reading a single excel file from sharepoint

Posted on 2011-02-16
6
455 Views
Last Modified: 2012-05-11
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
Comment
Question by:sirbounty
  • 3
  • 3
6 Comments
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 250 total points
ID: 34908305
0
 
LVL 67

Author Comment

by:sirbounty
ID: 34910011
I don't quite follow the first step on that second link...the first link appears to be what I've already tried...
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34914501
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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 67

Author Comment

by:sirbounty
ID: 34918083
"Open Shared Services from central administration." - where is this?
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34924591
You do have access to central administrator of the Sharepoint Server right?

http://technet.microsoft.com/en-us/library/cc263312(office.12).aspx
0
 
LVL 67

Author Closing Comment

by:sirbounty
ID: 35097979
Couldn't get this working, so I abandoned the project for now.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question