ParaGlow
asked on
VBA in SharePoint
If an Excel spreadsheet with some VBA code is loaded into a SharePoint library, will the vba code still work ? Or do I have to convert the code to UDF ? Thanks.
ASKER
Thanks, Rob. So if the spreadsheet is rendered in the browser, the vba will not work ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To view or edit the file it would still have to be downloaded onto the User's machine and opened using the local installation of Excel. Assuming the local installation is compatible with the code in the downloaded workbook there is no reason why it would not work.
Compatibility issues could include:
- version of Excel, 2010, 2013 etc
- 32 or 64 bit
- macro security settings
Thanks
Rob H
PS A UDF is still VBA but triggered by a formula rather than an event or command.