![]() We have to make sure that the developer tab is available in an Excel sheet in order to get started with the development, using VBA. In this article, we will see how we can make use of VBA Macros to write validation logic to check for data correctness before saving Excel sheets and uploading to SharePoint.Įxcel Workbook used for the demo is uploaded Manual validations are time consuming and not the best way to go when the Excel data sheet isĬomplex and numeric computational formulas are involved. Human errors can creep in to the Excel sheets, if there are no validations. Prerequisite, if we want to ensure data correctness. ![]() SharePoint can store the documents of various formats, the common formats being MS Word and MS Excel documents.Data validations in an Excel sheet is a
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |