Solved

Reading a single excel file from sharepoint

Posted on 2011-02-16
6
454 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

822 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