So I was working on a project and was faced with a little issue. You see, I created a program which processes files that are generated by a web application and that get downloaded to the user’s PC. The problem is that if the file already exists, Windows helpfully adds a numeric prefix to differentiate the files.
I thought I’d just share that today was the big day in the Microsoft MVP community as today was the day that MVPs were awarded/re-awarded their MVP title.
Technology Pros: We recognize exceptional community leaders for your technical expertise, positive influence on those around you and commitment to solving real world challenges with cutting-edge technology.Microsoft
You can use the search page to examine how the current awardees are in the various fields/countries/…
If you’re not up on the news, Microsoft has decided to deprecate and remove VBScript!
Well, 96% of people indicated that they want to learn more about creating Slider controls.
So, in this post, I start covering the subject by introducing the ‘simplest’ (maybe not quite, but what you would think would be the simplest) slider control built entirely using a couple label controls and a command button.
I will post a few more articles in the coming days that will cover other possibilities:
I’m always amazed at the level of pure stupidity that Microsoft exudes at times!
I know, we all have our moments in the sun, myself included, but Microsoft just seems to manage to outdo themselves.
I’m well aware that in an ideal world, Microsoft wants us all running MS365 and thus we would have all migrated all of our existing Web Browser controls to use the ‘new’ Modern Web Browser control, but that isn’t reality, not even close! The fact of the matter, the legacy Web Browser control is still fully supported and thus why fix something that isn’t broken. Beyond which, many people are simply not running MS365 so they don’t even have access to the Modern Web Browser control at all.
All of this to say, that many a database are still using the ‘Legacy’ Web Browser control, thus IE (Internet Explorer)!
For those of you that have followed this blog over the years, you know that I’ve explored various image manipulation tools, things like:
Well, I decided to explore another option, ImageMagick.
Executing Command Prompt commands and capturing their output is a task that often arises unexpectedly. Whether you need to run DOS commands or command-line utilities, integrating this functionality into your VBA program can enhance its capabilities.
Surprisingly, Microsoft has not provided a straightforward way to execute these commands directly within VBA, leaving users to devise their own solutions. The need for this functionality spans various scenarios, from simple commands like `dir` and `ipconfig` to more complex command-line utilities, showcasing the true potential of this integration.
A quick search online reveals numerous solutions, many of which involve complex API calls or writing outputs to text files—approaches that can be overwhelming.
In this article, I’ll share a couple of simple methods that have proven effective for me over the years.
Continue reading
Every once in a while when manipulating string odd things happen that can be hard to figure out.
Ever needed to make a PC Shutdown, Reboot, Hibernate, … after running some code?
As with most things, there are a number of possible approaches, but today I thought I’d demonstrate a very simple solution using the Shutdown command:
Ever needed or wanted to be able to lock the PC? Perhaps after running your code?
Well it is surprisingly simple to do!
Luckily for us, there is a simple API we can implement to do all the heavy lifting. All we need to do is build a simple wrapper function around it as demonstrated below:
