Does SharePoint support VBA?

Question

I read very little information about Sharepoint (SP), and most of my reading focused on sales overview. I am disposing of VBA with Office applications - especially Access - on a regular basis, and I am wondering if there is any translatable way to save custom writing functions of my own VBA in Sharepoint, especially with MS Access.

I read that Access databases can be run in SP, with tbales to be listed and generated in InfoPath, but I assume that they mainly talk about Access database applications that were created using wizards, which consist mainly of related objects without explicitly defined code.

Most of my applications are mostly VBA driven code because of my automation requirements, which I will describe my tasks for. Can I do the same in SP, and can anyone point out any links to this topic in particular?

Answer 1

You can use Access to distribute your interface to users, no matter how much VBA it has, but the application with the VBA code in it will not be converted to run in a browser as a web database in SharePoint SharePoint Services Access Services. To do this, you need to use new, more powerful macros and limit yourself to the functions supported by web objects. For an existing application, this means restoring each object from scratch.

Do you need to run the Access application in a web browser? If not, then you bark over the wrong tree here.

Answer 2

AFAIK Sharepoint does not support VBA.

Answer 3

If you publish an Access database to SharePoint as a web database, it cannot use VBA, however you can create a hybrid with tables in sharepoint and frontend in Access, so you can have as many VBA etc. as you like , and still have the benefits of storing your data on a SharePoint SQL server. You can save the interface to Sharepoint and upload it via sharepoint.

An alternative is to save the traditional Access database on Sharepoint Share and access it via webDAV, rather than the Sharepoint web interface. You can map the sharepoint library as a local drive to simplify it.