Date: Mon, 30 Jun 2008 17:05:35 -0400
Reply-To: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject: Re: Sharepoint question
Content-Type: text/plain; charset="us-ascii"
Why does the SharePoint app have different pages per site instead of
different folders (if that's actually the case)? Sounds as if developers
of the nifty "VBS scripts" and SharePoint developers are working in
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Monday, June 30, 2008 2:10 PM
Subject: Sharepoint question
To begin with, I'm sorry for posting a non-SAS question, but I really
don't know where else to turn.
I'm trying to automate a reporting application (which primarily uses
SAS), the end result of which is a ZIP file sitting on a file server on
our network. The PC application is "nifty" and complicated, remote
submitting SAS Access to Oracle queries on a UNIX server, exporting
results to an Access database on my PC, generating and executing VBS
scripts to update multi-sheet Excel pivot tables and zipping the result
to the file server, all scheduled using Windows Scheduled Tasks.
The last thing I must do is go to a SharePoint site for each ZIP file
and update the reference to point to the new file. All I do is type
over the name in a box labeled "URL" with the new file name and click
the "Save and Close" button on the form.
I can see the full URL of the SharePoint page (running something with an
I have very limited experience with either. (Okay, I have no experience
This is tedious and silly; there must be some way to automate it. Any