In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
I have a doc library on SharePoint for my work templates (DOTX). The doc library has a column called "Template ID". Each template has an ID stored in that column. I want to use VBA to loop through ...
I'm in the enviable position of having to support a client who wants to maintain and manipulate a complicated business spreadsheet in Excel, and then push a selection of that data to a list in ...
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 ...