Searching Calendar Events With The Microsoft Graph API

Working off of my existing demo and previous posts:

How-to Send E-mails Via Outlook Using The Microsoft Graph API
Well, unless you’ve been living under a rock, by now, you are aware of some fundamental changes coming to Outlook in the not too distant future, mainly the fact that it will cease to support any form of VBA! Now, many have tried to make Microsoft reverse course, understand the millions of solutions (Access, Word, Excel, …) that will instantaneously break with such a switch, but there has been no change in course.  Actually, per the usual, there has been little to no response whatsoever. This brings us to today’s post!  
Use The Microsoft Graph REST API To Create An Event In The User's Calendar
So after my recent YouTube video on sending an e-mail via an Outlook.com account using the Microsoft Graph REST API: I thought I’d provide a function which can be used to create an event in the user’s calendar. (it is still a work in progress though)

 

I wanted to share 2 routines I’ve created for searching/listing events in a calendar.

Continue reading →

Identify Your User ID With The Microsoft Graph REST API

There can be instances in which you need to identify a user’s Microsoft Graph REST API ID, so their user id.

This can be useful at time for running certain HTTP requests for a specific user. Retrieve information, Create/Edit/Delete elements associated with their account (contacts, calendar events, e-mails, …)

Continue reading →

Microsoft Graph REST API Bug When Applying a $select=id

As you all have noticed by now, I have been exploring implementing the Graph REST API to interact with Outlook components: E-mail, Calendar, Contacts, …

How-to Send E-mails Via Outlook Using The Microsoft Graph API
Well, unless you’ve been living under a rock, by now, you are aware of some fundamental changes coming to Outlook in the not too distant future, mainly the fact that it will cease to support any form of VBA! Now, many have tried to make Microsoft reverse course, understand the millions of solutions (Access, Word, Excel, …) that will instantaneously break with such a switch, but there has been no change in course.  Actually, per the usual, there has been little to no response whatsoever. This brings us to today’s post!  
How-to Send E-mails With Attchments Via Outlook Using The Microsoft Graph API
So, a few weeks ago I published articles and videos of how we can implement Microsoft’s Graph API so we could send e-mails: creates calendar events:
Use The Microsoft Graph REST API To Create An Event In The User's Calendar
So after my recent YouTube video on sending an e-mail via an Outlook.com account using the Microsoft Graph REST API: I thought I’d provide a function which can be used to create an event in the user’s calendar. (it is still a work in progress though)

 

Well, I’ve encountered an oddity that I qualify as a bug.  I’m still investigating, bug have been able to reproduce the issue multiple times now (every time in fact).

Continue reading →

How-to Send E-mails With Attchments Via Outlook Using The Microsoft Graph API

So, a few weeks ago I published articles and videos of how we can implement Microsoft’s Graph API so we could send e-mails:

How-to Send E-mails Via Outlook Using The Microsoft Graph API
Well, unless you’ve been living under a rock, by now, you are aware of some fundamental changes coming to Outlook in the not too distant future, mainly the fact that it will cease to support any form of VBA! Now, many have tried to make Microsoft reverse course, understand the millions of solutions (Access, Word, Excel, …) that will instantaneously break with such a switch, but there has been no change in course.  Actually, per the usual, there has been little to no response whatsoever. This brings us to today’s post!  

creates calendar events:

Use The Microsoft Graph REST API To Create An Event In The User's Calendar
So after my recent YouTube video on sending an e-mail via an Outlook.com account using the Microsoft Graph REST API: I thought I’d provide a function which can be used to create an event in the user’s calendar. (it is still a work in progress though)

Continue reading →

Why Does Microsoft Help Hackers?

I’ve been dealing with my father’s PC, installing a fresh copy of Windows and everything else because he got himself hacked…

SHERTACK Tech Scam - A Warning For Others
Well, I had a fun afternoon yesterday! I received a phone call from a family member informing me something was up with my father’s PC. I connected to find remote access to his PC, all his antivirus, anti-malware programs removed…. then to boot, he was on the phone with the scammers! I started by getting him to hang up on them, but they’re persistent and called back numerous times thereafter.

and the more I set things up, the more I realized how badly Microsoft does security!  How they literally set their users up to fail from the start.

Continue reading →

How Popular Is Microsoft Access, Really?!

I decided to have a little fun after seeing Mike Wolfe’s recent article:

How Many People Use Microsoft Access?
Anecdotal estimates vary wildly. After scouring the internet, I’ve only found one (semi-) official number. And it’s probably a lot higher than you think.

 

and see what I could dig up.

You see, I don’t think Microsoft’s own numbers are accurate.  With later versions of Windows and Office, yes, they have telemetry, but there are multiple older versions still in use that they have no visibility on whatsoever!

This is why there is no true way to get an exact number.  It’s educated guess work at best and pure speculation at worst.  That said, we can get a better idea relative to other databases via surveys and various sites that rank such data.

Below is some data I found by searching online, so let’s see what picture the data is showing.

Continue reading →

A VBA Procedure To Open A File In Windows Notepad

As part of my recent work for a client request, refer to my previous post:

Appending A String To An Open Instance Of NotePad
I had a bit of a weird request recently and thought I’d share the solution in case anyone else ever needs to do the same thing. The request was simple: Append data from a database, at the click of a button, to the open NotePad instance.

I tried to explore Notepad’s command-line switches.

Information on this is relatively hard to find, typical poor support documentation from Microsoft!, but this is what I could find from various sources:

  • /A <filename> open file as ansi
  • /W <filename> open file as unicode
  • /P <filename> print filename
  • /PT <filename> <printername> <driverdll> <port> print filename to designated printer

So as you can see, it is possible for Notepad to launch in either ANSI or Unicode modes!

Continue reading →

How-to Create Linked Tables Via VBA

Although we have GUI tools to create Linked tables, at times, it is simply more convenient to do so via VBA and automate the process.

So I thought I’d quickly share my routine for doing so. I’ve made it primarily for 2 usage scenarios, creating linked tables to:

  • Microsoft Access databases
  • SQL Server/Azure SQL databases

Continue reading →