Questions related to Visual Basic for Applications (VBA)

learn more… | top users | synonyms

1
vote
1answer
71 views

SSRS Code Behind and SharePoint

I have a couple of general questions about using VB code with SSRS reports in SharePoint. I have noticed that when I use an expression on my report, the expression only talks to the data that is in ...
0
votes
1answer
18 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 ...
0
votes
1answer
54 views

Visual Basic infopath print button XDocument not declared

I have an InfoPath form where I am trying to add a print button and add visual basic to print the form. What I have done so far: 1) Add a button to the form 2) in button properties click edit form ...
0
votes
1answer
90 views

Export Access table to SP with display control Combo box

I have table in MS Access, that has following lookup properties: Display control: Combobox Row source type: Value list Row source: "Option 1";"Option 2";"Option 3" And I want export this table to ...
0
votes
1answer
1k views

VBA - copy folder - checkout required

I'm using an access database to generate a folder full of files. I want to copy the folder to sharepoint. I'm trying to do this by programmatically mapping the sharepoint library to a network drive, ...
0
votes
1answer
124 views

Pulling Reports from SharePoint 2007 using VBA on a Recurring Event

Is there any code that will pull in all items listed on a recurring event that has a future start date? We have created a Calendar List for each of our clients with recurring tasks that the payroll ...
0
votes
1answer
5k views

Add and Update Single Item in Sharepoint List via VBA

I am trying to add and/or update single items in a SharePoint list via VBA and I found a similar question: But I have to say that I can only delete items with this code and I am not familiar with ...
0
votes
1answer
408 views

Uploading a document to a SP 2010 server via VB6

I'm currently trying to upload a file to a SharePoint 2010 server from within a VB6 application. Unfortunately I can't use any .NET or other additional libraries. I've read a couple of suggestions ...
1
vote
0answers
31 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: ...
1
vote
0answers
7 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 ...
1
vote
0answers
14 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
218 views

sharepoint - accessing excel files from VBA

I'm trying to access SharePoint directory from Excel VBA and loop over all files at this directory. But when I try to refer to the directory, then I get this error in return: Path not found I ...
1
vote
0answers
22 views

Link Access to a SharePoint file whose name keeps changing

I have an Access database that I would like to link to an Excel file located on SharePoint. Normally, this is easy to accomplish as SharePoint/MS Office are well integrated. The problem is, the Excel ...
1
vote
0answers
152 views

SharePoint 2010 - Custom Property can't be accessed in VBA for brand new files

I have a Document Library in SharePoint 2010 which will be used to receive Excel files via email. I have created a column/property called "Status". The default value for this is "New". I email an ...
1
vote
0answers
21 views

Workbook.CheckIn always produces an error the first time it's called? (x-posted on StackOverflow)

This question is cross-posted on SO here. I have some workbooks stored in a document library on Sharepoint 2007. I want to check out a workbook, modify it, and check it back in. Using the following ...
1
vote
0answers
77 views

Access Version History and Approval from Word Macro

Our word document templates include a table that includes a version history and a second table with the list of approvers of the document. I would like to populate these tables from a VBA macro that ...
1
vote
0answers
153 views

VB script to automate importing sharepoint list data to excel

I need to automate pulling data from SharePoint list data to excel through writing a VB Script (not VBA). How can I import data directly from a SharePoint List into Excel using VB script? Currently, ...
1
vote
0answers
302 views

Upload file to Sharepoint from outlook attachment using VBA

I am trying to automate the process to save a file (.PDF,.docx, etc) to the Sharepoint site our team is using but a file that is coming in the form as an Attachment in an Outlook form. It is a custom ...
1
vote
0answers
201 views

Ms Access Linking To Sharepoint List

I have a SharePoint list with about 40,000 records * 4 columns I have linked the share point list in MS Access and attempted to run a query selecting all the records in the list into a local table to ...
0
votes
0answers
19 views

Newly Added Files Cannot be Opened from VBA?

I am using the following VBA code to open a file on SharePoint. This code works just fine for any other file on SharePoint but I cannot get it to work on one specific file. I recently added this ...
0
votes
0answers
75 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 ...
0
votes
0answers
30 views

Save the modified date from sharepoint to sharepoint drive

I got this VBA Excel document where I map a network drive which is the sharepoint drive folder that I have admin rights for. The problem is that when people publish their document then the sharepoint ...
0
votes
0answers
16 views

Creating a network of files that can reference eachother

Sharepoint novice here (readas: extreme novice) Is there a way to make it so that multiple files can be dependent on eachother? IE: If there is a master list excel file with multiple sheets worth of ...
0
votes
0answers
37 views

Performance Optimization when loading Termsets

I have a problem with retrieving the terms of a termset in my program (which is written in VB). The termset has about 300 terms, and all of them have about 10 to 70 subterms. I wanted to integrate all ...
0
votes
0answers
51 views

Insert Content Type Quick Part with VBA in Microsoft Word 2013

I have a macro-enabled document I'm using with a content-types enabled from SharePoint. I know there is a way create a custom document property, but I don't think this does what I need--I need a ...
0
votes
0answers
26 views

Document_Open Macro Won't Start

I'm using a simple Document_Open macro to display a message box to anyone opening a Word form. This macro worked without a problem until I uploaded it as a document template in a SharePoint 2013 ...
0
votes
0answers
42 views

Run VBA macro after synchronizing with the Sharepoint

I have a MS Project file synchronized with the list on the Sharepoint. I want to run a VBA macro just after synchronization is done (after I click File -> Save As -> Sync with SharePoint). How to do ...
0
votes
0answers
221 views

Filter XML results from REST API call to SP list data

I was curious if it was possible to use VBA to send a query inside a REST API call to a sharepoint (SP) site in order to extract data from the SP list? I've looked around and I can't find an exact ...
0
votes
0answers
23 views

How to create a remotely callable service to query aggregated list data from sharepoint

We have the following scenario: multiple lists that are linked via lookup columns and a few "configuration" lists that contain special timespans (calendar events) relevant for classifying the events ...
0
votes
0answers
38 views

Import SharepointList into Outlook template as BCC

I am trying to import a Sharepoint list into a BCC field of an Outlook oft email template. When user will click on the sharepoint linked oft email template, a new email message will open, BCC field ...
0
votes
0answers
102 views

Copy the docs/(word/excel/zipped folders) from Sharepoint document library to local folder

I have to pull (copy) the documents and folders (Zipped) stored in document library of sharepoint 2010 site into local folder using Excel VBA. I am new to VBA and have no idea how to start with this. ...
0
votes
0answers
6 views

How to retrieve AD Informations from Custom Application Page (Using VB)

I've just created a new application page (aspx with VB). I can't find any solution to gather their AD informations (specific attributes) without asking them their password twice (first time when they ...