VBA – Open Image With Paint

Microsoft Paint Icon

So, since I’ve recently had a few posts regarding opening images in Microsoft Photo Viewer, MS Photos:

VBA - Open Image With Windows Photo Viewer
Ever had the need to specifically open an image in Windows Photo Viewer? I’ve provided a multitude of ways to open files:   but what if we don’t necessarily want to use the default application and want to specifically open the image in the Windows Photo Viewer?
VBA – Open Image With MS Photos
Relating to a question in my previous post in which David Marten inquired about doing the same in MS Photos, I decided to look into the matter. I was surprised at that I couldn’t locate any examples of this. The only ones that would work were if MS-Photos was already defined as the system’s default…

Continue reading →

I thought I’d also demonstrate how easy it is to open an image in Paint as I know many people love to use Paint.

Continue reading →

VBA – Open Image With MS Photos

Microsoft Photos Icon

Relating to a question in my previous post

VBA - Open Image With Windows Photo Viewer
Ever had the need to specifically open an image in Windows Photo Viewer? I’ve provided a multitude of ways to open files:   but what if we don’t necessarily want to use the default application and want to specifically open the image in the Windows Photo Viewer?

in which David Marten inquired about doing the same in MS Photos, I decided to look into the matter.

I was surprised at that I couldn’t locate any examples of this. The only ones that would work were if MS-Photos was already defined as the system’s default image editor, then you could use any approach to launch the file and it would obviously open in MS-Photos (nothing easier that FollowHyperlink).  Sadly, having MS-Photos as the default editor is not likely and messing with users’ registry wasn’t an avenue I wanted to use.

I went through 100s of threads and not 1 worked!

Continue reading →

VBA – Open Image With Windows Photo Viewer

Ever had the need to specifically open an image in Windows Photo Viewer?

I’ve provided a multitude of ways to open files:

Open Files, URLs and More Using VBA and PowerShell
This is another post in my recent series of posts regarding using PowerShell to empower any VBA application. Today, I thought I’d look at how PowerShell could offer a solution to launching files. No surprise here, PowerShell easily rose to the occasion! PowerShell CmdLets I happily started out developing a function using the Invoke-Item CmdLet,…

Continue reading →

VBA - Opening Files and URLs
So what does a developer do when he can’t sleep? He explores what options can be used to open files and/or URLs, of course! In this article I will attempt to explore multiple appraoches that can be used to open files and URLs using VBA, the choice of which one to use is left to…

Continue reading →

 

but what if we don’t necessarily want to use the default application and want to specifically open the image in the Windows Photo Viewer?

Continue reading →

VBA – WIA – Check If A File Is In An Acceptable Format

Over the years, I’ve released a number of posts and functions for working with images using WIA:

Convert To Grayscale
VBA – WIA – Convert Image to Grayscale
Today, I thought I’d add to my library of image manipulation functions and I set out to see if there was a way, using WIA (Microsoft Windows Image Acquisition Library), to convert an image to black and white, well to be more precise to convert it to grayscale. I originally searched high and low and…

Continue reading →

VBA – WIA – Flip an Image
I was helping out in a forum discussion regarding manipulating images, specifically flipping them and published some of my code there, so I thought I’d share it here for everyone else to benefit from. Once again, WIA has everything we need to quickly and easily perform this task! WIA offers developers 2 properties: FlipHorizontal and…

Continue reading →

VBA - WIA - Convert the Image Format
I was continuing to explore the power of Windows Image Acquisition (WIA) and put together the following function to convert an image from one format to another.
VBA - WIA - Rotate an Image
I was recently exploring automating WIA because I wanted to help someone out in a forum and wanted to see what else it could. It is actually quite impressive and versatile . Below is a very simple function I put together to rotate an image which can be configured to use either Early or Late…

Continue reading →

so on and so forth!

Continue reading →

Power Automate – Delay Action

Microsoft Power Automate Icon

Just a quick word of caution with an issue I recently encountered while trying to develop a Power Automate – Flow.

I won’t bore you with all the details, but I was building a branch of a Flow and needed to add in a pause/delay and so I added a Delay Action. Everything worked fine.

Then my client decided that they no longer wanted a delay, so I set the delay Count (the interval) to 0 and saved my worked.

A little while longer, I received failure notices stating:

The provided ‘Wait’ action interval count ‘0’ is not valid. This must be a positive integer.Microsoft Power Automate

Continue reading →

Access – Determine a Label’s Associated Control

I’ve previously posted how we can determine the label which is associated with a control:

MS Access - VBA - Determine a Control's Associated Label
It can become necessary to need to determine the associated label to a given control. It actually is, yet again, very simple to do. Not what I’d call intuitive, but easy once you are aware of the proper synthax to use. To reference a control’s associated label you use the following synthax Me.ControlName.Controls(0) Or Forms!FormName.Form.ControlName.Controls(0)…

Continue reading →

There, in the comments, David asked how we could do the inverse, that is determine the control associated to a given label.  At the time I wasn’t aware of any simple solution, but today Bruce Hulsey was kind enough to share with us that there was indeed a simple solution.  Building upon his statement, below is a function we can use to determine to which control a label is associated:
 
Continue reading →

VBA – Extract Base URL From A Full URL

Ever needed to get the Base URL (also referred to as Origin) from a full URL?

So given a URL like:

http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZAC

get/return:

http://office.microsoft.com

Well, it truly isn’t hard once you know how. Below are a couple different approaches that you can employ to get the job done:

 
Continue reading →

VBA – Validate If A URL Exists

When we’re going to work with a file, it is usually a good idea to first test to ensure the file exists. The same is true in the world of web programming.

For instance, I have an article that demonstrates how you can download files from a URL:

Download a File From The Internet
Today, I thought I’d expand a little on a post I made in 2013: to adapt the routine to download a copy of the file.  This was actually brought upon by someone needing assistance in Experts-Exchange. The General Idea Based on the original sample, we can read the file using XMLHTTP and then we can…

Continue reading →

and in it I trap the error that the file/resource cannot be accessed/located.  That said, it would be a good idea, to start off, by checking to ensure that the domain URL exists.

Furthermore, such functions can also be useful for validating data entry to ensure that someone didn’t make a typo.
 
Continue reading →