Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [vba]

Questions related to Visual Basic for Applications (VBA)

0
votes
0answers
11 views

Update SharePoint List Using Excel VBA: Person or Group Field Data Type Error

I have successfully written code in VBA that allows me to import/link to a SharePoint list and to synchronize changes. I also have code that allows me to append a new row/recordset one at a time. ...
1
vote
0answers
21 views

Understanding Access's automagic authentication to SharePoint Online

I'm trying to automate SharePoint tasks from Microsoft Access using the REST API (since the CSOM is not available in VBA). This, however, requires me to authenticate. I usually authenticate to ...
0
votes
0answers
20 views

VBA to retrieve sharepoint list with a condition

The following code extracts the list perfectly. However, i'm looking for help to extract it based on a condition. Dim objMyList As ListObject Dim objWksheet As Worksheet Dim strSPServer As String Dim ...
0
votes
0answers
14 views

Is it possible to create a form and send the output to different group email lists based on one field choice?

For example if location B is selected from the drop down is it possible to create a script or somehow have sharepoint email the entered data as a cc'd email to a list of people? We're trying to create ...
1
vote
1answer
22 views

Need timestamps for the completion of each stage in a work process flow

I'm using a MS SharePoint-based Intranet site to track and report the status of a requisition as it moves through its review processes. There are six stages in the process flow and, for performance ...
0
votes
0answers
47 views

Set username/password programatically when importing list into Excel using vba

When I run this code (Excel macro, vba) it prompts for authentication. How can I set username, password in order to automate it? I use MS Excel 2013 and import from SharePoint 2016. Sub importlist()...
1
vote
1answer
195 views

SP Online REST API Change the Content Type of a Document Library Item

I would like to change the Content Type of items in a SharePoint On-Line Document Library, using VBA and the REST API. I would like to change existing Folders to a custom Content Type, derived from ...
1
vote
0answers
19 views

Call VBA of Word template from .NET at server side using Sharepoint Server?

Can i call a VBA macro of a Word document, using .NET and Sharepoint Server? I mean, in a .NET client environment i can do this: oW = CreateObject("Word.Application") oW.Documents.Add("template.dotm")...
0
votes
2answers
280 views

SharePoint REST API - update metadata Document Library Item when value string includes apostrophe (single quote) character

I want to update a metadata column for an item (document set) in a SharePoint document library using REST API (via VBA). The below (vba) code extract/simplification works fine for simple cases, for ...
0
votes
0answers
18 views

Search for a file in Sharepoint using Extra Attachmate VBA

I'm working on a project with Extra Attachmate macros (VBA script) along with mainframe. I need to fetch a value from Mainframe session and search in sharepoint (2013). I couldn't pass the value to ...
0
votes
0answers
30 views

PowerPoint slides on SharePoint are deleted while opening from Excel with VBA

I run a VBA macro from Excel that has to open PowerPoint presentations on SharePoint, read something from a slide and write it to Excel. The Makro ran on a Windows 10 VM for some weeks without any ...
0
votes
0answers
74 views

Create Document Set using VBA

I need to create Document Set in Sharepoint library, using VBA code. My current code creates Folders in library, using command MkDir, but i need to find out how to create Document Set instead. Thanks ...
0
votes
0answers
11 views

SharePoint workflow from list to create a changelog file

So i'm brand new to sharepoint and i've been assigned a task to see if its possible to create a flow so that when a list is updated/new row is added it saves those changes in an excel file or similar ...
0
votes
1answer
639 views

Unable to upload to SharePoint Online via VBA

I have tried using the below code to upload a document to SharePoint Online (Sourced from this answer) Dim SharepointAddress As String Dim LocalAddress As String Dim objNet As Object Dim FS As Object ...
1
vote
0answers
683 views

Connect/Authenticate SPO with VBA (excel)

I am trying to connect to Sharepoint Online with Excel VBA script to create or delete items in a list. The problem is how to authenticate properly to SPO. I have checked the site with instruction: ...
1
vote
0answers
331 views

VBA: Get request on a SharePoint list

I'm trying to get elements of a Sharepoint list with VBA to show and use them in an Excel sheet. The normal get request on MSXML2.ServerXMLHTTP60 Dim xmlObj as Object Dim sUrl as String sUrl = "...
0
votes
1answer
320 views

GetListItems Sharepoint Online

I'm currently trying to complete a table with information from the items of a Sharepoint Online list, using VBA code executed from Microsoft Word macro. I've successfully managed to achieve this when ...
0
votes
1answer
288 views

Getting version number into the spreadsheet

I have a spreadsheet on a spreadsheet located in a SharePoint library. Major and minor versions are enabled. I am trying to get names and values of some columns (metadata/properties) into the ...
0
votes
1answer
28 views

Document rolling back unexpectedly?

In my office we store an Excel document on SharePoint for everybody to enter data onto as the days and weeks go. I am tasked with reviewing this data and making sure it correct each month. We had some ...
1
vote
1answer
926 views

Syncing SharePoint metadata with Excel

I have a spreadsheet in a SharePoint Online library. The library has several columns of metadata, say A, B, C and D. The first two are text and next two are numbers. I would like to do two things: I ...
1
vote
0answers
516 views

Get the library name from GUID in VBA

I want to pull information from a SharePoint 2016 list in VBA. Below Code is what I found and that is working without depending on a view. Unfortunately the SQL query uses the list Name. A user could ...
1
vote
1answer
1k views

Call SharePoint web service from excel macro vba

I have called SharePoint web service from excel macro VBA with following code from here: Sub CallService() Call Add_Item("List1", "https://contoso.sharepoint.com/sites/site1/", "test item", "...
4
votes
2answers
961 views

Error in update changes from Excel to SharePoint using macro vba

I have load the SharePoint online list in excel using following VBA code from here: Sub ImportListFromSP() Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets(1) Dim src(1) As Variant ...
0
votes
1answer
551 views

vba script to add items to SharePoint online list

I have a vba script which captures the user input from the outlook and updates an excel sheet. I want the vba script to write into a sharepoint list in a SharePoint online site. Please let me know how ...
0
votes
1answer
156 views

Create list items from uploaded excel spreadsheet

I am fairly new to doing anything in SharePoint, other than basic operations. I have been tasked with creating a SharePoint 2013 site with the following operations: Upload a selected Excel ...
0
votes
1answer
51 views

Is it possible to have an user-interface and macros on sharepoint?

Context I'm making a project on a company that must have an user interface and a database or work directly over an excel. Also I need this on SharePoint. Info The problem is that in the company, ...
0
votes
2answers
376 views

Excel VBA Moving SharePoint Folder

Due to SharePoint's 5000 item limit, I want to run an Excel VBA program to archive folders from a SharePoint "Active" Folder to another SharePoint Folder, called Completed. The only solution I can ...
1
vote
1answer
78 views

How to limit the length of sharepoint multiline field through vb?

I want to limit the maximum number of characters in multi-line text field of a sharepoint list programmatically in VB. I found a field UnlimitedLengthInDocumentLibrary, by making this as true it ...
0
votes
1answer
66 views

Use VBA to Relocate Folders from Old SharePoint Site to New Site

I'm currently tasked with relocation ~13,000 project folders from an old SharePoint site to our new site. Each folder will have contents, sub-folders, contents within those folders, etc. I'm sure ...
0
votes
2answers
135 views

Why is SharePoint not showing latest version of GIF?

Why is SharePoint not showing latest version of GIF? I'm using a VBA script in Excel to export and upload a diagram to SharePoint. This happens twice a day, which means I'm going to check for ...
0
votes
1answer
1k views

Excel VBA code to export chart as JPG and upload to sharepoint?

Currently I'm using the following code to export my diagram as JPG and save it in the worksheet directory. Sub exportDiagram_Click() Dim myChart As Chart Dim filePath As String Set ...
0
votes
2answers
4k views

Sharepoint properties update using Excel VBA

I am able to upload files to Sharepoint through VBA but I'm not able to update these properties to have their properties updated with 'Document Status' and 'Confidentiality' Fields. Until these are ...
1
vote
0answers
125 views

Upload documents SharePoint : Problem updating metadata

I have written a code to copy files from a folder to SharePoint using FS.CopyFile LocalAddress, SharepointAddress But when I do it manually it asks me for Document status & Confidentiality I'...
1
vote
0answers
42 views

Adding/updating column tags after populating a new document with bookmark values

Im currently running a project for a customer with the goal to automate a SharePoint environment along with word templates. So far i managed to create a word template which includes a Userform where ...
1
vote
0answers
79 views

Copy paste the value from one cell to another based on condition using VBA [closed]

Below are my steps that I need to perform in excel. and I wanted to automate this as & when I run Macro :) Background : I have already imported one sheet from another workbook and recorded the ...
0
votes
1answer
533 views

UpdateListItems Error: Data at the root level is invalid. Line 1, position 1

I´m trying the UpdateListItems web service but I always get following error in the response file: Data at the root level is invalid. Line 1, position 1. GetList, GetListItems and DeleteList works. ...
0
votes
1answer
44 views

Absolute beginner. Fell in the deep end

I have been tasked with maintaining and upgrading an infopath form that my predecessor created. I have absolutely 0 background on this particular form and he had no documentation as to where this form/...
1
vote
0answers
652 views

Authentication error when trying to map SharePoint drive through VBA

In a 2010 Excel file I have a macro that downloads an Access database file from an external 2007 SharePoint site by mapping the SharePoint folder to an open drive. I've distributed the file to other ...
0
votes
1answer
226 views

Is there a way to get an Excel doc that uses a visual basic feature to show in SharePoint?

.com/GNU92.png First image shows the blue filled in date sections in the Excel doc. This is the desired display format of the doc. Second image shows what is displayed in SharePoint. No blue date ...
2
votes
1answer
4k views

Create sharepoint document folder using VBA

I need to find a way to programmatically, using Excel VBA, create a folder in a Sharepoint Document Library. The Sharepoint Document Library already exist, and it has already one level of folders in ...
0
votes
1answer
46 views

InfoPath Conditional Arguments

I am developing a form in InfoPath to publish to Sharepoint 2010 that will have to do some calculations based on inputs. I am trying to set the value of one field based on the input from 2 option ...
0
votes
1answer
2k views

VBA code to determine whether a SharePoint file is checked out?

I've written a VBA program to examine each Excel workbook in a SharePoint folder and perhaps move it to another location. It turns out that rarely (but not never) a user is currently editing a ...
1
vote
2answers
7k views

Open File in a Sharepoint list via VBA

I want to open an excel file in a Sharepoint list via VBA. Here is my code: Sub OpenWB() Dim SummaryWB As Workbook Dim vrtSelectedItem As Variant With Application.FileDialog(msoFileDialogOpen) ....
1
vote
1answer
2k views

How to authenticate and log on to SharePoint 2013 using excel vba

I have to fetch data from a file in SharePoint 2013 using VBA and I am mapping the SharePoint site to my network drive and accessing the file. This is working fine when I had already signed in with my ...
1
vote
0answers
499 views

Which library do I have to include to use SPListItem in VBA?

I want to read and modifiy SharePoint Lists with VBA from within Microsoft Excel 2013. Unfortunately I can not find which library I have to include to use those commands like described here: https://...
1
vote
0answers
29 views

Require SharePoint Multi-Edit Version Comments in MS Word

My SharePoint library is set up not to force checkout as we want to multi-edit documents. However, after a document is edited, we want to be able to enter a brief summary of why/what was changed. I ...
2
votes
1answer
164 views

From Excel 2010 is it possible to attach a PDF file to a list item.

I have the list item ID and I have the location of the PDF file, it is created using the excel sheet and now I want to attach it to a list item.
0
votes
1answer
52 views

NullReferenceException SPListItem

Sub lookup() Dim sptSite As SPSite = New SPSite("https://internalsite/sites/trial") Dim sptWeb As SPWeb = sptSite.OpenWeb() Dim sptList As SPList = sptWeb.Lists("TestList") Dim sptItems As ...
1
vote
0answers
45 views

How to get an Excel table's Summary property from JavaScript on the client side using the Ewa namespace

Background: The value of the Summary property corresponds to the setting of the Description box in the Alternative Text dialog box, which is displayed by right-clicking on an Excel table and then ...
1
vote
0answers
621 views

How to download and upload data from an excel spreadsheet stored on a SharePoint site into a local excel spreadsheet?

I am exploring a method to download and upload information from an excel spreadsheet stored on a SharePoint Site from a VB based form in a local excel file. Can you please assist me in understanding ...