Posts filtered by tags: VBA[x]


 

Geocoding & Reverse Geocoding Functions In Google Sheets

Last updated: 28/08/2018, 1 min read (without the code) Introduction In the previous post, we learned the basics about developing and using a custom function in Google Sheets. It is time now to switch to something more advanced compared to our first example. We have seen in the past how to use Google’s geocoding services from VBA. Here we will see how to call these services using Google Apps Script (GAS). The main advantage when developing a GAS function is that, unlike VBA, you don’t need to....
Tags: Google, Seo, VBA, Christos Samaras, Google Sheets, Google Apps Script


Website Log-In Automation With VBA

Introduction In the last few months I saw a lot of people struggling to automate the log-in procedure to various websites using VBA. To be honest, web-related tasks can be considered as advanced VBA topics, since in many cases require basic knowledge of HTML language. In this post I will try to provide some insights about how to automate the log-in procedure via VBA. More precisely, I will analyze the concept behind a reusable macro that I developed. The macro creates a new instance of Internet....
Tags: Seo, Office Tips, VBA, Christos Samaras


Get & Set The Default Windows Printer With VBA

Last updated: 15/07/2018, 2 min read (without the code) Introduction Although VBA is a great language for building Office “applications”, when it comes to handling Windows devices, such as a printer, for example, things start to become difficult. The obvious reason is that the VBA was not designed for this kind of purposes. However, what if your VBA “application” needs to know how many printers are installed and available in the particular computer? What if your “application” must set the... ...
Tags: Office, Seo, Office Tips, VBA, Christos Samaras


Get Image Size In Pixels With VBA

Last updated: 19/02/2018, 2 min read (without the code) Introduction People who are interested in digital photography taking seriously the size of the images that they take. The dimensions of an image – width and height – can be easily spotted in the Windows Explorer. If you hover your mouse over an image file you will see a pop window showing its dimensions. Alternatively, you can right-click on an image file, select properties on the menu that pop-ups and then, in the Properties form, go......
Tags: Seo, Office Tips, VBA, Christos Samaras


How To Get A Free Google API Key (August 2018 Update)

Last updated: 09/08/2018, 4 min read Introduction During the previous years, I published several VBA functions that used Google web services, such as Geocoding, Elevation, and Directions. These functions worked in the same way: a properly formatted request was sent to the Google server, and, then, a response was received in XML format. If the response was successful, the requested field was retrieved (latitude, longitude, elevation, trip distance etc.) by reading the XML file. These VBA... ...
Tags: Google, Seo, VBA, Christos Samaras, Useful Stuff


Reverse Geocoding Using VBA & Google API

Last updated: 09/08/2018, 1 min read (without the code) Introduction After updating the existing VBA functions that dealt with Google APIs, it is time to introduce a new function that can be used for Reverse Geocoding, a short definition of which, based on Wikipedia, is the following: “Reverse geocoding is the process of back (reverse) coding of a point location (latitude, longitude) to a readable address or place name. This permits the identification of nearby street addresses, places,... ...
Tags: Google, Wikipedia, Seo, Office Tips, VBA, Christos Samaras


Open A Password-Protected PDF File With VBA

Last updated: 03/05/2018, 2 min read (without the code) Introduction In the past, we have seen two ways to open PDF files with VBA: the first one involved the usage of the Adobe Object Model and it could be only used with Adobe Professional. The second one was more generic; it was taking advantage of the Windows API functions and it could be used by both Adobe Reader and Professional. Both ways worked and continue to work just fine. There is a problem, though: what will happen if the PDF file....
Tags: Seo, Office Tips, VBA, Christos Samaras


Get Laptop's Battery Information Through VBA

Last updated: 03/07/2018, 1 min read (without the code) Introduction As the title indicates, in this post we will learn how to get several properties related to the battery of the laptop that runs our VBA code. Unfortunately, VBA does not have any built-in functionality that can be used to retrieve this kind of information. Therefore, with the help of WMI we will get the following battery properties:AvailabilityBattery statusChemistryEstimated charge remainingEstimated run timeTime on... ...
Tags: Seo, Office Tips, VBA, Christos Samaras


Excel VBA: Programming For Complete Beginners, Step-By-Step Illustrated Guide

Hi my name is William B. Skates and i'm the author of Excel VBA: Programming for Complete Beginners the book is focused on beginners who want to dive into the world of VBA and help them understand the various loops, string functions and arrays used in Excel VBA. The book is written in an easy to understand way by using illustrations to learn by doing.The book just entered its free promotion from 11/10 to 15/10. I would love to hear your thoughts down in the comments below. https://www.amazon.co...
Tags: Books, Self-promotions By Authors And Publishers, VBA, William B Skates


Geocoding & Reverse Geocoding Functions In Google Sheets

Last updated: 28/08/2018, 1 min read (without the code) Introduction In the previous post, we learned the basics about developing and using a custom function in Google Sheets. It is time now to switch to something more advanced compared to our first example. We have seen in the past how to use Google’s geocoding services from VBA. Here we will see how to call these services using Google Apps Script (GAS). The main advantage when developing a GAS function is that, unlike VBA, you don’t need to....
Tags: Google, Seo, VBA, Christos Samaras, Google Sheets


Learn to master vlookup and VBA with this Excel $49 training bundle

If you’ve got the tools, you’d better have the talent, so right now, you can get in on training that’ll have Microsoft Office and its most popular program eating out of your hand. A lifetime of access to eLearnExcel and eLearnOffice School training bundle is now only $49, over 90 percent off its regular price, from TNW Deals.
Tags: Startups, Microsoft Office, Offers, VBA


How To Get A Free Google API Key (August 2018 Update)

Last updated: 08/08/2018, 4 min read Introduction During the previous years, I published several VBA functions that used Google web services, such as Geocoding, Elevation, and Directions. These functions worked in the same way: a properly formatted request was sent to the Google server, and, then, a response was received in XML format. If the response was successful, the requested field was retrieved (latitude, longitude, elevation, trip distance etc.) by reading the XML file. These VBA... ...
Tags: Google, Seo, VBA, Christos Samaras, Useful Stuff


Get & Set The Default Windows Printer With VBA

Last updated: 15/07/2018, 2 min read (without the code) Introduction Although VBA is a great language for building Office “applications”, when it comes to handling Windows devices, such as a printer, for example, things start to become difficult. The obvious reason is that the VBA was not designed for this kind of purposes. However, what if your VBA “application” needs to know how many printers are installed and available in the particular computer? What if your “application” must set the... ...
Tags: Office, Seo, VBA, Christos Samaras


Get Laptop's Battery Information Through VBA

Last updated: 03/07/2018, 1 min read (without the code) Introduction As the title indicates, in this post we will learn how to get several properties related to the battery of the laptop that runs our VBA code. Unfortunately, VBA does not have any built-in functionality that can be used to retrieve this kind of information. Therefore, with the help of WMI we will get the following battery properties:AvailabilityBattery statusChemistryEstimated charge remainingEstimated run timeTime on... ...
Tags: Seo, VBA, Christos Samaras


Microsoft VBA versus Applescript

I am dusting of my coding skills that were pretty much put on hold in the early 1990s and have started to program macros to automate the mechanics of the template store: creating individual slides and thumbnails for PowerPoint and Keynote in different aspect ratios of these design.Things in the Microsoft Office ecosystem run smoothly ("VBA"), for Mac, a lot less so. Applescript is a language that aims to automate pretty much everything you can do in Mac OS. It has been around for a very long tim...
Tags: Apple, Software, Microsoft Office, Powerpoint, Keynote, Speaking, VBA, Microsoft VBA, Boris Stefanik


Writing macros in PowerPoint

The last time I used macros in PowerPoint was probably back in the 1990s during my time as an analyst at McKinsey. Yesterday, I picked things up again where I left them of.To my surprise, the record function is no longer available (at least on a Mac). This used to be my secret weapon: record something very roughly, analyse the automatically generated code, and re-write that in a better way. The fastest way to learn the macro language.Now you have to go through the process of learning VBA via the...
Tags: Speaking, Mckinsey, VBA, Markus Spiske, MSDN


Open A Password-Protected PDF File With VBA

Last updated: 03/05/2018, 2 min read (without the code) Introduction In the past, we have seen two ways to open PDF files with VBA: the first one involved the usage of the Adobe Object Model and it could be only used with Adobe Professional. The second one was more generic; it was taking advantage of the Windows API functions and it could be used by both Adobe Reader and Professional. Both ways worked and continue to work just fine. There is a problem, though: what will happen if the PDF file....
Tags: Seo, VBA, Christos Samaras


Sourcecon Spring 2018 the recap Day 2 Programmers Sessions!!

Sourcecon Spring 2018 day 2, Programmers Sessions.   First up Chris Comrie Hot to Build Community to get Candidates. Lots of talk about Social Sites such as; Twitter, Facebook, Tumblr, Pinterest etc. TOOLS; AWS, Linkedin Helper, Dux Soup, Follow Liker, Facebook Auto Finder. Six steps to build communities. 1-Build Customer Avatars, 2-Establish Your Secret Sauce, 3- Build a String Following, 4-Turn Followers into Superfans, 5-Convert Superfans into Customers, 6-Be Seen Everywhere.   Next up Mike...
Tags: Jobs, United States, Ruby, VBA, Da Costa, Dean Da Costa, Chris Comrie, Twitter Facebook Tumblr Pinterest, Mike Notaro, Github Stackoverflow LI Twitter FB, Sanebox Product Hunt Angel


Reverse Geocoding Using VBA & Google API

Last updated: 21/03/2018, 1 min read (without the code) Introduction After updating the existing VBA functions that dealt with Google APIs, it is time to introduce a new function that can be used for Reverse Geocoding, a short definition of which, based on Wikipedia, is the following: “Reverse geocoding is the process of back (reverse) coding of a point location (latitude, longitude) to a readable address or place name. This permits the identification of nearby street addresses, places,... ...
Tags: Google, Wikipedia, Seo, VBA, Christos Samaras


How To Get A Free Google API Key

Last updated: 24/02/2018, 2 min read Introduction During the previous years, I published several VBA functions that used Google web services, such as Geocoding, Elevation, and Directions. These functions worked in the same way: a properly formatted request was sent to Google server, and, then, a response was received in XML format. If the response was successful, the requested field was retrieved (latitude, longitude, elevation, trip distance etc.) by reading the XML file. These VBA functions....
Tags: Google, Seo, VBA, Christos Samaras, Geocoding Elevation


Get Image Size In Pixels With VBA

Last updated: 19/02/2018, 2 min read (without the code) Introduction People who are interested in digital photography taking seriously the size of the images that they take. The dimensions of an image – width and height – can be easily spotted in the Windows Explorer. If you hover your mouse over an image file you will see a pop window showing its dimensions. Alternatively, you can right-click on an image file, select properties on the menu that pop-ups and then, in the Properties form, go......
Tags: Seo, VBA, Christos Samaras


Australia: VBA thwarted in battle against combustible cladding - Holding Redlich

The VBA cannot direct builders to fix existing cladding problems, so owners will continue to face significant costs.
Tags: News, Australia, VBA, Redlich


Microsoft Considers Adding Python As an Official Scripting Language in Excel

An anonymous reader writes: Microsoft is considering adding Python as one of the official Excel scripting languages, according to a topic on Excel's feedback hub opened last month. Since it was opened, the topic has become the most voted feature request, double the votes of the second-ranked proposition. "Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))," the feature request reads, as opened by one of Microsoft's...
Tags: Python, Microsoft, Tech, VBA


You can still get these 5 deals at Black Friday prices

If your food coma caused you to miss out on all of the Black Friday deals, we’ve got your back — you can still get all of the following items from the Boing Boing store at their lowest-ever prices. Universal Waterproof Solar Charger Anyone who’s always looking for an excuse to escape civilization for the weekend will love a Universal Waterproof Solar Charger. This power pack houses a massive 5,000 mAh battery that can fully recharge up to two Android or iOS phones at once using just sunlight. I...
Tags: Google, Post, News, Microsoft, Edward Snowden, Shop, CPD, VBA, PC Magazine


How California ranks as a place for veterans to live

More vets live in California than any other state, but that might not be for long. Here’s a look at how California ranks in several categories for veterans and what the future might hold. Best places to live This week the personal finance website WalletHub released its report on the best and worst places for veterans to live. The report compares the 100 largest U.S. cities, using 17 metrics. California has more than 1.73 million veterans and had 17 cities ranked. Here’s a look: You can see t...
Tags: Florida, Politics, News, California, Uncategorized, California News, Events, Infographic, Sport, Best, Things To Do, Soccer, Military, Veterans, Va, Associated Press


Playing With Photoshop From Excel VBA

Last updated: 05/11/2017, 1 min read (without the code) Introduction Adobe Photoshop is probably the most famous raster graphics editor that is available on the market for almost three decades. You can do amazing things with this software. I have only played with it for a few hours, and I was quite surprised with the results. One of the things that intrigued me the most was the ability to program it. So, in this post I will take the opportunity to show you how to:Resize an image.Modify an...
Tags: Seo, VBA, Christos Samaras, Christos Samaras Date, Len FilePath


Perl is the Most Hated Programming Language, Developers Say

Thomas Claburn, writing for The Register: Developers really dislike Perl, and projects associated with Microsoft, at least among those who volunteer their views through Stack Overflow. The community coding site offers programmers a way to document their technical affinities on their developer story profile pages. Included therein is an input box for tech they'd prefer to avoid. For developers who have chosen to provide testaments of loathing, Perl tops the list of disliked programming languages,...
Tags: Microsoft, Tech, Delphi, Robinson, David Robinson, PERL, VBA, Kotlin, Thomas Claburn, PHP Objective C CoffeeScript


VBA gets Excel almost running itself, and this $29.99 training will show you how

While Excel changed the way we handle data, VBA (Visual Basic for Applications) takes that data manipulation to new energizing heights. If you’re ready to take your spreadsheets and business information to startling new places (in a fraction of the time you usually spend), get in on this limited time offer for a double pack of Microsoft VBA courses, on sale now for only $29.99 from TNW Deals.
Tags: Startups, Offers, VBA, Microsoft VBA


Event announcement

On July 21 at 9 a.m., the Virginia Bar Association will present a program entitled “The Roberts Court at Age 11: The 2016 U.S. Supreme Court Term in Review.” Speakers will include Deepak Gupta, Toby Heytens and Marcia Coyle; Bill Hurd will serve as moderator. More information about this event, which is part of the bar association’s summer meeting, is available on the VBA website. The post Event announcement appeared first on SCOTUSblog.
Tags: Law, VBA, Marcia Coyle, What's Happening Now, Virginia Bar Association, U S Supreme Court Term in Review Speakers, Deepak Gupta Toby Heytens, Bill Hurd


I don’t have enough

It’s been a rough week. We’ve been migrating our file storage for Highrise and you can imagine how difficult that is for a product running since 2007 with millions of users.And it wasn’t going that well.Fortunately, we had enough backup procedures in place to handle most problems. But still, on Thursday morning at 3AM I was nervously watching the error queue for more fires.How’d I get here?I don’t mean that in a negative sense. This barely raised my blood pressure. I’ve been in this same situat...
Tags: Business, Entrepreneurship, Careers, Startup, Blogging, Signal, McCaffrey, Andersen Consulting, VBA, Software-development, Michael Dwan, Tony McCaffrey