Category Archives: Office 365

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

CTO Article April 2020

These are the good reads found in this month. During covid-19 work from home topics and secure your work from home environment related discussions are popular. Azure Database Migration Guide, this guide give you ideas to move almost from any … Continue reading

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

SharePoint users with permission but could not see some of the folders in Document Library

This short post shows you one of the possible ways to resolve the issue, SharePoint users with permission but could not see some of the folders in Document Library. Go to the folder in Document Library. Click the information and … Continue reading

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

SharePoint The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

This post will show you one of the ways to loop the folder with hitting the error “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator”. The pre-requisite for this article is that … Continue reading

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

Microsoft Graph get users

This post get you the complete code for getting the user from Microsoft Graph. You will find a link https://docs.microsoft.com/en-us/graph/api/user-get?view=graph-rest-1.0&tabs=http, Get a user. In order to achieve this, you need another link. The following code combine the code from the … Continue reading

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

Power BI remove Favorites + frequents

This post shows you how to remove Favorites + frequents from Power BI portal. You cannot remove them but to remove the access from where you Share them. Watch the video here https://youtu.be/FDCg0m8n6B0.

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