Questions related to Visual Basic for Applications (VBA)

learn more… | top users | synonyms

1
vote
1answer
449 views

Import Sharepoint list via VBA in specific view

I am currenty trying to import a Sharepoint list in an Excel sheet via VBA and thanks to this: Import Sharepoint List into Excel Using VBA Only It is working pretty well, but if i leave the "VIEWNAME" ...
0
votes
1answer
26 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
635 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
111 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
3k 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
310 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
5 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
15 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
124 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
20 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
0answers
10 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 ...
0
votes
0answers
6 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
13 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
22 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, ...
0
votes
0answers
42 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
5 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 ...
0
votes
0answers
89 views

How to get the Last Modified Date and Time of an Excel file in a Sharepoint using VBA?

i am creating a macro file with command buttons that when you click it, it will display the properties esp the last modified date and time of an Excel file uploaded in a SharePoint site. How can i do ...
0
votes
0answers
76 views

Creating a file via VBA leads to Check-in Stalemate

We have Sharepoint 2010 Enterprise. I want to create a series of workbooks for salespeople, each one personalized, and with a different name . I want to have check-out enabled on the target doc ...
0
votes
0answers
122 views

Any access vba/macros code to read/write to SharePoint O365 list using REST API

Can anyone help me with a sample code to read/write to SharePoint O365 list using REST services. I have searched the net and i see examples for excel that im unable to use in access. Also the other ...
0
votes
0answers
76 views

Access SharePoint forms (Picture/Slide Library) from Powerpoint using VBA

We are developing a Sharepoint site, which includes a presentation library and a picture library. We have a PowerPoint Add-in coded with VBA already, and would like to extend this to interact with the ...
0
votes
0answers
117 views

excel macro to vlookup sharepoint list

I am trying to create a macro that looks up data (vlookup) from a SharePoint list. Once done, I want all the contents in my excel file to replace those in the SharePoint list. I can do all this from ...
0
votes
0answers
21 views

Find, replace and save in advance Rich text editor

I need to build/develop a processor with Visual Studio 2010 that finds some letter/character, changed it as desired ('>' into 'ê', '^' into 'â' etc) and save in Time New Roman font with a single ...
0
votes
0answers
99 views

How to insert new records on an sharepoint list from EXCEL VBA

I have an worksheet with the code below and I wanna populate a SharePoint list with it, but the code returns me the error: It isn't possible update the changes while there is validation errors in ...
0
votes
0answers
186 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 ...
0
votes
0answers
90 views

Request list of files and last updated file info?

I have to access to a SharePoint folder. I want to save and read updated Excel sheets periodically. I'm using WinXP with Excel 2003 (VBA) on the client side. I read a lot of stuff, but nothing ...
0
votes
0answers
103 views

Exporting MS Access Report to Sharepoint Site

I have an MS Access database that contains reports that I would like to export as pdfs and automatically upload to a SharePoint site. Currently, I'm exporting the reports manually and manually ...
0
votes
0answers
126 views

RTE 2501 when using OutputTo to save to a SharePoint 2010 document library, but works fine when saving to local HDD

I have an MS Access 2010 databases that creates a PDF and then saves the file to a SharePoint 2010 document library. This had been working fine for a couple of years, but now I am getting a 2501 ...