Posts filtered by tags: Office Tips[x]


 

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 Public IP, Local IP & MAC Address Using VBA

Introduction As the title implies, today we will learn how to retrieve the local and the public IP address, as well as the MAC address of a computer using VBA. First of all, the definition of IP address according to Wikipedia is the following: “An Internet Protocol address (IP address) is a numerical label assigned to each device (e.g., computer, printer) participating in a computer network that uses the Internet Protocol for communication. An IP address serves two principal functions: host or.....
Tags: Mac, Wikipedia, Seo, Office Tips, Christos Samaras


Playing With Photoshop From Excel VBA

Last updated: 06/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, Office Tips, Christos Samaras


Automatically Adjust Secondary Y Axis Scale Through VBA

Introduction Some days ago, while I was checking the discussions on an Excel-related group on LinkedIn, I bumped into an interesting question about charts. The question was “how to automatically set the secondary Y axis scale via code, so that both primary and secondary axes share the same number of gridlines”. I thought this question was interesting for two reasons: first, it’s quite common to include a secondary Y axis on a chart, just to display another series that have different scale... ...
Tags: Seo, Office Tips, 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


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


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


How To Find A Chair That Makes Your Butt Happy

Did you know that the average American sits six to eight hours a day? That is because in the modern American office, most of us are unfortunately anchored to our desks. There are plenty of studies that address the impact of sitting for prolonged periods of time, and to summarize, it isn’t that good for you. And while frequently getting up and moving around is absolutely the best thing you can do for your health, you shouldn’t underestimate the importance of a good office chair. A good office cha...
Tags: Happy, Ergonomics, Lifehacks, Chair, Office Tips, Buying Guides, Office Chair, Butt, Office Needs, Boss Traditional Black Executive, Office Star Space


Office Style: COLOR

With emboldened hues, we welcome Office Style back into our lives this week…  As we head into the second month of the new year we are already starting to daydream of warmer weather here at the Navy Yard. This week we started to see pops of color announce the otherwise subtle transition into longer days, the style around the office seemed to welcome the sunshine ahead with open arms. + Which look are you loving? Let us know in the comments below!  Check out more Off...
Tags: Fashion, Shopping, Color, Office Tips, Trending, Free People, Style tips


The Best Ways to Deal With a Noisy Coworker

Your office isn’t always conducive to distraction-free work, especially when you have noisy, obnoxious coworkers. Here are a handful of tips that help you politely tell someone to STFU without it blowing up in your face.Read more...
Tags: Psychology, Work, Jobs, Relationships, Office, Office Tips, life-hacks


Amazing Home Office Makeover: Small Spaces Edition

Amazing Home Office Makeover: Small Spaces Edition Amazing home offices don’t just happen. They are made. We took our industry knowledge to a small, unused space that sat just between two tall dressers in an apartment bedroom. The results were a home office that that was both functional and quite pretty! Here’s our next installment of Home Office Makeover: Small Spaces edition! Home offices are definitely trending. Kids are leaving the nest later, more mid-career adults are working from home or...
Tags: Organization, Lifehacks, Notebooks, Office Supplies, Pencils, Office Ideas, Office Tips, Office Fashion, Paper Art, Office Desk, Office Design, Post It Notes, Staplers, Organization & Efficiency, Swingline


Eight Microsoft Word Shortcuts You May Not Know

If you use Microsoft Word for work, or on any regular basis, you know how much time a couple of quick shortcuts can save you, especially if you use them every day. This graphic runs down eight tips for Word that may be familiar to daily drivers, but still useful for students, office workers, and resume builders alike.Read more...
Tags: Time Savers, Infographics, Microsoft, Microsoft Office, Shortcuts, Microsoft Word, Office Tips, life-hacks


Eight Useful Microsoft Excel Shortcuts Worth Memorizing

Many of us live and die by our spreadsheets, but every true spreadsheet ninja has to start somewhere. These helpful, Excel shortcuts can help you save time and get more done. From highlighting every cell at once to quickly copying formulas, they’re a refresher for experts and worth remembering for beginners.Read more...
Tags: Infographics, Microsoft, Excel, Graphics, Microsoft Office, Spreadsheets, Shortcuts, Office Tips, Microsoft Excel, Excel Tips, Excel Shortcuts


6 Infographics to Help You Run Your Business Better.

Small business owners have it tough. Not only are you the brains behind your operation but you also have the task of being a jack of all trades. We know that this doesn’t come easy. Not everyone who owns a brick and mortar location understands the nuances of designing a website. Older business owners might not have the slightest clue of how to harness social media to their advantage. We’re here to help. We scoured the internet to find the best bite sized infographics to help you run your busines...
Tags: Infographics, Social Media, How To, Jack, Business Tips, Office Tips, Work Better, Small Business Tips, Marketing Tips, Organization & Efficiency


PDF Search Through VBA

Introduction The motive behind this post came from an email question that I received from a blog reader during the previous weekend. Jason wrote: “I am trying to create a link from Excel to search in a PDF file”. So, in this post I will try to give an answer to this question. In general, there two possible solutions in this problem (OK, maybe there are other solutions that I am not aware of), both of which having their own advantages and disadvantages. The FindText method Syntax: ...
Tags: Jason, Adobe Professional, Office Tips, VBA, Christos Samaras, Christos Samaras Date, JSO


Send AutoCAD Commands From Excel & VBA

Introduction About three weeks ago I received an email request from Mohammed. He asked me if it is possible to send AutoCAD commands directly form Excel. To cut a long story short, the answer is yes and the proposed solution is based on the SendCommand method of AutoCAD, which sends a command string from a VB or VBA application to the document to be processed. If the drawing specified isn’t active, it will be made active. This method processes any AutoCAD command-line function, includin...
Tags: Autodesk, Control Panel, Office Tips, VBA, Christos Samaras, Christos Samaras Date


Drawing Points In AutoCAD Using Excel & VBA

Introduction During the previous weekend a blog reader (Denis) sent me an email asking me if it is possible to draw points in AutoCAD from Excel. The answer is quite straightforward and is YES. The proposed solution involves the AddPoint method : RetVal = object.AddPoint(Point) Where: RetVal: Point object. The newly created Point object. Object: ModelSpace Collection, PaperSpace Collection, Block – the objects this method applies to. Point: Variant (three-element array of doubles); ...
Tags: Denis, Office Tips, VBA, Christos Samaras, Christos Samaras Date


Using Windows Environment Variables In VBA

Introduction According to Wikipedia: “ Environment variables are a set of dynamic named values that can affect the way running processes will behave on a computer. They are part of the operating environment in which a process runs . For example, a running process can query the value of the TEMP environment variable to discover a suitable location to store temporary files, or the HOME or USERPROFILE variable to find the directory structure owned by the user running the process. They were i...
Tags: Microsoft, Wikipedia, Office Tips, VBA, Christos Samaras, Christos Samaras Date, USERPROFILE, Len Environ, Environ VBA


Geocoding Using VBA & Google API

Introduction According to Wikipedia: “Geocoding is the process of finding associated geographic coordinates (often expressed as latitude and longitude) from other geographic data, such as street addresses, or ZIP codes (postal codes). With geographic coordinates the features can be mapped and entered into Geographic Information Systems, or the coordinates can be embedded into media such as digital photographs via geotagging”.Almost 10 months have passed since my last posts about Google ...
Tags: Google, Microsoft, Wikipedia, Office Tips, VBA, Geographic Information Systems, Christos Samaras, Christos Samaras Date, GetLatidue


Calculating The Area Of A Simple Polygon Using The Shoelace Algorithm

The basics It has been quite a while since the last post about mathematical algorithms, so today we will learn how to apply the shoelace algorithm in order to calculate the area of a simple polygon. First of all, what is the definition of “simple polygon”?According to Wikipedia: ” In geometry a simple polygon is defined as a flat shape consisting of straight, non-intersecting line segments or "sides" that are joined pair-wise to form a closed path. If the sides intersect then the po...
Tags: Wikipedia, Office Tips, Simpson, Carl Friedrich Gauss, VBA, CTRL, Gauss, Christos Samaras, Christos Samaras Date


Insert Blocks In AutoCAD Using Excel & VBA

Introduction In the comments section of the previous post about AutoCAD and Excel interaction, a blog reader (Tim) asked me if it is possible to insert blocks in AutoCAD from Excel. I gave him some insight and I think that it's time to present the complete solution, which involves AutoCAD’s InsertBlock method. The code presented today is not new; it was written actually some months ago (in April). Anyway, according to AutoCAD VBA help, the structure of InsertBlock method is the followin...
Tags: Office Tips, Tim, WCS, VBA, Christos Samaras, Christos Samaras Date, RotationAngle, Range G i Value If Range H i Value, BlockScale Y BlockScale Z RotationAngle


Changing Excel Icon & Creating Workbook Shortcut With A Custom Icon

Introduction A common question when developing custom Excel applications is: “How to change the default icon of the main Excel window?” Another common question is: “How to change the default icon of the custom application, so as to not look like an Excel workbook?” Both questions address the same need; to customize the user interface. If you have spent countless of hours in workbook designing and code development, you always want to add a personal touch on the user interface of you...
Tags: Office Tips, DLL, VBA, Christos Samaras, Christos Samaras Date, ThisWorkbook Path \ My Icon ico, Shell Create


Get Public IP, Local IP & MAC Address Using VBA

Introduction As the title implies, today we will learn how to retrieve the local and the public IP address, as well as the MAC address of a computer using VBA. First of all, the definition of IP address according to Wikipedia is the following: “An Internet Protocol address (IP address) is a numerical label assigned to each device (e.g., computer, printer) participating in a computer network that uses the Internet Protocol for communication. An IP address serves two principal functions: ...
Tags: Mac, Wikipedia, Office Tips, VBA, OSI, Christos Samaras, Christos Samaras Date, Network Information Center NIC, Internet Assigned Numbers Authority IANA, TCP IP Local Area Network


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 I...
Tags: Facebook, Yahoo, Office Tips, VBA, Christos Samaras, Christos Samaras Date, PtrSafe Function ShowWindow Lib, MsgBox Sorry


Automatically Adjust Secondary Y Axis Scale Through VBA

Introduction Some days ago, while I was checking the discussions on an Excel-related group on LinkedIn, I bumped into an interesting question about charts. The question was “how to automatically set the secondary Y axis scale via code, so that both primary and secondary axes share the same number of gridlines”. I thought this question was interesting for two reasons: first, it’s quite common to include a secondary Y axis on a chart, just to display another series that have different sca...
Tags: Office Tips, VBA, Christos Samaras, Christos Samaras Date


Ditch those Mindless Office Meetings

Office meetings are inevitable in a business, but sometimes they can get a little mindless. The agenda for productive team meetings are often planned out ahead of time to increase efficiency. We’ve partnered with the Marbles, LLC‘s marketing team to bring you 5 tips to increase productivity and creativity in staff meetings. It’s time to ditch those mindless office meetings! Ditch those Mindless Meetings: 5 Tips from Marbles CEO Will Scott 1. “Throw out the concept of traditional weekly staff m...
Tags: Office Ideas, Promotional Products, Boxa, Marbles, Office Meetings, Office Tips, Will Scott, Mindless Office Meetings, Marbles LLC, Nina Barbero, Marbles LLC Marbles LLC, Bonita Springs