Category Archives: Microsoft Office

Excel VBA loop through SQL Azure database

In the previous article, hIttps://chanmingman.wordpress.com/2020/06/07/excel-vba-loop-through-sql-server-database/, is connect from VBA to SQL Server on premise. Now, you can use VBA to connect to SQL Azure database and populate the Excel sheet. The code is almost 95% the same except you will … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged , , | Leave a comment

Read Json file using Excel

This post shows you how to read Json file using Excel. Json file is kind of popular today. Excel does build in the feature to read Json file. I am using Office 365 Pro Plus. I am sure you can … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged , | Leave a comment

Excel VBA loop through SQL Server database

Excel VBA is still popular today. I believe some people out there is still looking at how to write a VBA to read a SQL database table then loop through it and put the value back to the Excel sheet. … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged , | 1 Comment

ODBC to SQL Azure DataSource.Error: ODBC: ERROR [HY024] [Microsoft][SQL Server Native Client 11.0]Database is invalid or cannot be accessed

This article shows you how to connect to SQL Azure using ODBC in your Windows operating system and resolve the error above. First you need to install ODBC Driver 17.0 or later. 1. Open ODBC Data Sources (64 bit) from … Continue reading

Posted in .Net, Cloud, Community, Data Platform, Microsoft Office, Office 365 | Tagged , | 1 Comment

Getting started with VBA in Office

This is nothing new, but I am amazed when I have seen this article posted in August 2019. This is also proven it is not about how cool you can code, it is about you can code something that can … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged , | Leave a comment

Microsoft Forms Pro

This post guide you to Microsoft Forms Pro in the way I understand. When I reach https://formspro.microsoft.com/en-us/ then start to worry how much I need to pay for this because in order to create your Form with question with Italic … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged , | Leave a comment

SharePoint client library code CSOM

Complete basic operations using SharePoint client library code https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-client-library-codee?WT.mc_id=DP-MVP-36769 Not sure why is this still around Build Windows Phone apps that access SharePoint https://docs.microsoft.com/en-us/sharepoint/dev/general-development/build-windows-phone-apps-that-access-sharepoint?WT.mc_id=DP-MVP-36769 Develop SharePoint Add-ins https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/develop-sharepoint-add-ins?WT.mc_id=DP-MVP-36769 Create a provider-hosted add-in that includes a custom SharePoint list and content … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, sharepoint | Tagged , | Leave a comment

SharePoint get full file path

This post shows you how to get the full file path. In order to do that you need to add Document Location in Quick Access area on top of your Office App. Follow the video below to add the Document … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged | Leave a comment

SharePoint How to Tag documents

This post has a video showing you how to Tag the documents in SharePoint. The Tag and Notes in SharePoint has obsolete. Watch the video below if you want to Tag a document in SharePoint. https://youtu.be/8C36WZreRqQ Resource: https://www.kalmstrom.com/Tips/SharePoint-Online-Course/Categorization-Enterprise-Keywords.htm

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged | Leave a comment

Excel cell data type

This post shows you a workaround to handle Excel data type. The Excel empty cell data type does not belong to any common type such as string, integer, or datetime. The data type is actually called System.RuntimeType. So if you … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged , | Leave a comment