Questions tagged [vba]

Questions related to Visual Basic for Applications (VBA)

Filter by
Sorted by
Tagged with
0
votes
0answers
28 views

Unable to map SharePoint folder or access it via an Excel macro unless SharePoint is open in Internet Explorer

I posted a similar question on Stack Overflow a while ago, but didn't get any responses so far so thought I'd try here. Basically, I'm using an Excel macro to download a few files stored in a ...
0
votes
0answers
21 views

VBA unable to fetch the content type properties from Sharepoint

I have my SharePoint connected to my onedrive and use the following piece of code to save the file in the onedrive folders (Which in turn syncs to my Sharepoint) and update the content type properties....
0
votes
0answers
17 views

REST or ADODB? What provides the best performance of creating an Excel VBA tool?

I’m creating a small Excel VBA tool that performs basic CRUD operations to SharePoint lists. Ha-ha, I know, probably a terrible solution but it’s all we have or allowed to work with at the moment. I’...
0
votes
0answers
7 views

Data in MS Project

I have written a VBA macro to open multiple projects 1 by 1 and do some work and publish on them. But here I get to see weird behavior. At some random, macro stops because it is not able to publish a ...
0
votes
0answers
9 views

Publishing large Project plans using VBA

I have written a VBA macro to edit and Publish multiple Projects. Technically macro is OK but it is getting failed because Projects are getting too long to Publish. I have written a waitforjob() but ...
0
votes
0answers
23 views

combine 2 rest api queries to get data from 2 odata table

In my VBA macro, I am fetching data from Project Online OData using Rest API query. I need to fetch data(ProjectNames) from 2 tables(Projects,ProjectsWorkflowStageDataset) satisfying 2 conditions. An ...
0
votes
0answers
26 views

Upload all folder files to SharePoint document library

I am working on code which will upload all ShareDrive folder files to SharePoint Document library: I need this to be done via VBA I have an excel, at A2, there would be ShareDrive Path and A3 would ...
0
votes
0answers
21 views

Excel VBA to fetch Views information from SharePoint Document Library

I need to fetch the List of views and view information in SharePoint Library.How can I achieve it using Excel VBA. I tried to search around, but was not able to find relevant solution. Thanks in ...
0
votes
0answers
32 views

VBA get folder names using SharePoint REST API

I am very new to APIs and I am struggling to get Folder names from SharePoint Online via the REST API. In Word VBA I would like to populate a Userform field with all the Folder names within a ...
0
votes
0answers
17 views

Update Project Owner using VBA

How to update Project Owner/Project Manager using macro. I am able to update Status Manager of all Tasks in project but not Owner.
0
votes
1answer
376 views

Return last modified date/time in VBA

Been really struggling to figure out how to return the last modified date/time in VBA, a lot of posts suggest using the already existing call to FileDateTime modifying the URL to look as follows: \\...
0
votes
0answers
310 views

How to map Sharepoint 365 to network drive using VB script?

I am trying to map SharePoint Online 365 to network drive using VB script for my UFT test. Below is my test script. It used to work but the files need to be transferred to SharePoint online 365 and ...
0
votes
1answer
765 views

VBA Autheticate to SharePoint Office 365

I tried to follow the base instructions using this post (as it was the only one I could find) http://www.sharepoint-insight.com/2016/03/21/step-by-step-sharepoint-online-authentiaction-process-via-...
0
votes
0answers
43 views

Save Email Attachment to Sharepoint

I receive an automated report with a big .csv file. Flow is timing out for sending the email to sharepoint. Does anyone know if I can use VBA to save certain email attachments to sharepoint? Thanks.
0
votes
2answers
533 views

VBA Excel Retrieve SharePoint User Number By Name (not User Information List)

Below, I've got a little job to insert a record into a SharePoint list. The Requestor field is a "Person or Group" type field, and in the code, the... rst![Project] = Sheets("Sheet2").Range("B2")....
0
votes
1answer
223 views

How to access Enterprise Task Custom field in macro?

I need to use below function in my MS Project vba macro. Application.CustomFieldValueListAdd FieldID:=lookupfield, Value:=i It works fine for local field(field created locally in ms project in ...
0
votes
1answer
1k views

Sharepoint Document Library Hyperlink Metadata Using Excel VBA

I have VBA code written for my Excel document. This code saves the workbook in Sharepoint site and sets the metadata for the document library that the workbook is saved into. Working code to set ...
0
votes
1answer
3k views

SharePoint API and VBA - Access Denied

I'm trying to retrieve items from a SharePoint list using the SharePoint Web API. I'm coding in VBA, because a need to display the information in a Word document. However I'm getting the Access Denied ...
1
vote
0answers
407 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 ...
1
vote
1answer
43 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 ...
1
vote
1answer
2k 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
29 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
922 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
1answer
4k 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
4k 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
979 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
2answers
1k 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
961 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
38 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
2k 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
1k 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
3k 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
2k 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 ...
1
vote
1answer
780 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
246 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
83 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
763 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
160 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
97 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
170 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
3k 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
8k 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
175 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
45 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
106 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
981 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
86 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
1k 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
393 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
8k 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 ...