Questions related to Visual Basic for Applications (VBA)

learn more… | top users | synonyms

1
vote
1answer
332 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
1answer
81 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
27 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/...
0
votes
1answer
51 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 ...
0
votes
1answer
93 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) ....
0
votes
1answer
23 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
139 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
48 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
1answer
146 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
132 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
451 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
26 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 ...
1
vote
0answers
116 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 ...
1
vote
0answers
69 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: http://...
1
vote
0answers
16 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
20 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
184 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 ...
1
vote
0answers
27 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
208 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
25 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
101 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
208 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
361 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
234 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
24 views

View Version History from SharePoint using VBA

new to SharePoint and at the edge of my knowledge (but not comfort zone - GIMME MORE) with VBA/Java(?) I basically want to look at a SharePoint site and determine the version history; This, but with ...
0
votes
0answers
23 views

Missing columns when extracting list via VBA

I'm trying to extract a list from a corporate Sharepoint using VBA, but a key column does not get extracted. When I Export to Excel from Sharepoint, the column does get extracted. But I want to be ...
0
votes
0answers
24 views

Retaining the document version with “Export to Excel” delivers a runtime error

We have been working for a kinda long time now with a vba script for retaining the document version in an exported Excel spreadsheet. It was working pretty well, however, since a few days it delivers ...
0
votes
0answers
126 views

How to use VBA to save a word document to SharePoint library with custom metadata

Thanks for taking the time to look at this. I have a template that our sales team will use. I have written some code to replace save so that the file saves back to SharePoint. The library has a ...
0
votes
0answers
23 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
42 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
17 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
54 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
146 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 ...