sharepoint 2013

Hi, I am trying to establish error handling for when a SharePoint-based network file won't save properly due to it being locked for editing by another user. When this happens, I simply want network users to get a message box indicating that the data wasn't saved. They can then request the...

Hi Community - is there anyway i can use the following code to connect to a MS Access DB stored on sharepoint instead of my local machine or a shared drive? I ran into some issues with permissions, and found that this DB would need to be stored on sharepoint- any guidance? Public Sub...

My VBA just ran through and created 2 20meg Excel files and I've called the routine to send them to SharePoint. ' =========== SEND to SharePoint ============================ L = MsgBox("Do you want to send the finished files on SharePoint", vbYesNo, "SharePoint") If L = 6 Then...

Hello experts, this is my first post in this forum. I've searched a lot of posts over the last two days and just can't figure this out. Brief context of my problem: I built a Tableau report that uses Excel as datasource. The excel workbook is edited by a number of users and is stored in...

Hi, I have 6 word documents with a total 399 Check Content Control boxes, 399 Date Picker Content Control boxes along with a Rich Text Content Control box at the top requiring a name stored on a SharePoint site. These will be opened by 1000's of people, renamed and saved back to the same folder...

Hello I have a macro which pushes out the current excel workbook that I am in to various different SharePoint sites. I would like to be able to delete the previous version of the file. I have the name of the previous file stored in a variable called 'OldFileName'. I check that the file exists...

I have attempted to use the below VBA code to push updates from an Excel table that is linked to a SharePoint list. Sub UpdateSPList() Dim ws As Worksheet Dim objListObj As ListObject Set ws = ThisWorkbook.Worksheets(1) Set objListObj = ws.ListObjects("MITSC_ProductList")...

Hi, I'm having an issue with Excel (2016) is connected to a SharePoint (2013) list using Get & Transform; I'm using the imported data to populate columns in a field via Index(Match()) formulas Table[Field] type references. The issue I'm having is that modifying the underlying SharePoint List...

Hi I have a tool set up that consists of 3 excel workbooks and 4 sharepoint repositories. The first workbook has a number of macros that creates a user form to be completed, once completed and submitted the macro creates a pdf print of the form and saves it in one repository. It also writes...

Hello Team, I've exported a list of metadata from my SharePoint Document Set library. The library is where we manage our "kaizens" which are a kind of standardized meeting. For each kaizen, I've captured the Topic, Date, and Members who attended the meeting. Because the Member field in...

May you please provide me VBA code to Download OData feed into excel sheet from SharePoint Project Web App. my web link is like myCompanyname.sharepoint.com/sites/wpa Please see the details from where you can see the detailed info. https://blogs.office.com/2012/10/31/server-reporting-in-pwa/...

Hi, I’m having issues with tracking changes within Excel. I have been able to set up the track changes options but I seem to lose my setting when emailing or uploading the document to Sharepoint 2013. I’d like to create an approvals worksheet, the idea is people would enter their name beside...

Dear All, From the web link : https://support.office.com/en-nz/article/Use-a-shared-workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61 I have understood that the SHARED WORKBOOK feature in Excel, allows multiple user to read and write on a single EXCEL Workbook kept on a common...

Hi I need to grab everything after the last "-" (strings can have up to four "-") and if there is a space after the last "-" to not take the space. Please note that this formula is to work in SharePoint so some formulas may not work Examples: TEXT -(THIS VALUE) TEXT - TEXT -(SPACE)(THIS VALUE)...

Hi there I have created a pivot table using source data from a SharePoint List. There is a Month Year field that I added it to the Report filter in the Pivot Table. When I click on the filter though the only option it shows is ALL - not dates listed below as I would expect. There are no blank...

I am trying to bulk copy data off a excel sheet onto a sharepoint list. I do this by 100 rows at a time, but there are fields that have sevral lines in to cell, which crash my copy in paste into SharePoint. What I usually do is click on the cell and click backspace so the data comes on to one...

Hi, We have an internal SharePoint 2013 installation with powerpivot galleries and the BI center installed. They seem to be working fine, however, when I deploy a workbook with slicers that are supposed to have scrollbars my Windows 7 IE users (IE 11) DO NOT see the scrollbars. This renders the...

Hi. While this is my first post, I have been dipping into this board for too many years to contemplate for help on VBA and have always appreciated the resource. I manage a department SharePoint site as an administrator (with limited privileges) for the Sales Team. I have a number of workbooks...

Greetings! I have an Excel 2010 workbook that includes a table linked to my SharePoint 2013 site by a data connection. The SharePoint list feeds the table standard information that's managed on the SharePoint site, but I need the user of the Excel workbook to be able to enter text manually in...

Hi, We have mapped a network drive to a SharePoint Directory, while we are able to copy a file (using Macros) to this location, this file does not appear in SharePoint to the other users, the reason being that it is not checked in. Can you help/guide us on how to Check using Excel Macros. Let...