Solved

Creating a folder in SharePoint using VB in MS Access 2007

Posted on 2013-11-06
1
262 Views
Last Modified: 2013-11-06
Can I create a folder in SharePoint using VB from Access 2007?  If so, how?  
   Thanks,
        Bill
0
Comment
Question by:WestBillWest
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
WestBillWest earned 0 total points
ID: 39627596
Thanks, I figured it out,  simple.  I just copied the path from the Windows Explorer provided by SharePoint by clicking <Actions><Open With Windows Explorer>.   From there I used the MkDir() function to add a "Test" folder to that.

Code Example:
     Dim NewFolder, SharePointFolder as String

     ' Notice, no "http:"  but the double "\"
     SharePointFolder = "\\MainFolder\SubFolder\Bill\"  
     NewFolder = "Test"

     mkdir(SharePointFolder & NewFolder)
     msgbox ("Your New Folder, '" & NewFolder & "' has been created!")

Thank you,
     Bill
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

Suggested Solutions

Title # Comments Views Activity
Skype for Business 10 91
SonicWALL Net Extender stops being able to establish VPN connections 6 382
Excel To Access Database Transfer 14 80
Where is user Lync data stored 4 123
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

726 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