Tom’s Tutorials For Excel: Making Your Hyperlinks User-Friendly
When you put hyperlinks in cells on a worksheet, it’s a good practice to present them in a user-friendly, intuitive way. For example, the pictures show an original list of hyperlinked cells with their Microsoft-induced wordy screen tips. The modified list was created by the below macro to show those same cells more intuitively,
…
Tom’s Tutorials For Excel: Sorting Email Addresses by Domain and Recipient
Yesterday, I posted this method for parsing the recipient and domain names from an email address.
As an example of why you would want to separate a recipient name from its domain name,
…
Tom’s Tutorials For Excel: Parsing an Email Address for Recipient and Domain Names
If you have a list of email addresses and you want to parse the recipient and domain names, you can do so with the following formulas as shown in the picture. Note that the formulas will take into account the varying lengths of recipient and domain names.
…
Tom’s Tutorials For Excel: Verifying Your Internet Connection
With the help of an API declaration, here’s a method for verifying if the active workbook’s system is connected to the internet.
Thanks to MS Excel MVP Mike Alexander at Datapig Technologies for his help with this to include wireless connections in the verification process.
…
Tom’s Tutorials For Excel: Reading the Registry for Your Email (non-Web Mail) Client
Here’s a macro that reads your Registry and tells you the name of your email client. This does not include web mail such as accounts in Gmail and Yahoo.
My email client is Microsoft Outlook.
…
Tom’s Tutorials For Excel: Hyperlinking a CommandButton to the Internet
When you have an ActiveX CommandButton on a UserForm or embedded onto your worksheet, the FollowHyperlink method can take you to your favorite website.
In the above picture, the green CommandButton’s caption is the literal URL address.
…
Tom’s Tutorials For Excel: Updating Links (or Not)
You’ve no doubt seen this pop-up message upon opening a workbook:
To automatically update links sans VBA, if the work being done is always on your computer…
…In versions 2003 or before: Tools >
…
Tom’s Tutorials For Excel: Finding and Deleting Phantom Links
If you’ve ever wondered why this message pops up after you are sure you’ve deleted all your workbook’s links, well, join the club. It’s a common problem because some links can be difficult to find.
In my 20 years working with Excel,
…
Tom’s Tutorials For Excel: Taking Stock
Here’s a fast and easy way to download the daily pricing activity of a company’s stock, from the first day it went public up to its last closing date. The following macro uses Microsoft as an example.
Microsoft’s stock abbreviation is MSFT as defined by the strSymbol variable.
…
Tom’s Tutorials for Excel: Delete Hyperlinks, Keep Their Text
At some point you have probably inherited or created a worksheet that contains active hyperlinks, when all you want in the cells is the hyperlink text itself. It’s annoying to unwittingly click onto a hyperlink cell that interrupts your work by suddenly taking you away from your worksheet.
…
Tom’s Tutorials for Excel: Attach Workbook in Outlook Email to Multiple Recipients
With a macro from Excel, you can create an email in Outlook that will attach your active workbook and fill in the To field with a list of multiple recipients. Suppose you have a workbook that you email to the same people on a regular basis.
…
Tom’s Tutorials for Excel: List all link formulas’ locations and their source workbooks, sheets, and cells.
Tom Urtis gives us another one.
For link formulas in your workbook, you can list their sheet and cell locations, AND the name of their precedent source workbook,
…
San Francisco, California
1-925-310-4170
tom@atlaspm.com
