As I indicated in my Quicbbooks Part 1 of never post, I would post some Microsoft Access and other Quickbooks source code and blog entries, rather than do a more detailed step by step explanation. I hope this is helpful. Quick Explanation You can parse Quickbooks response using a ICustomerRetList – and I may post that […]
Continue readingCategory Archives: Tips and Tools
VBA solution: Scraping website information using MSXML, HTMLDocument, and getElementsByClassName
Summary An explanation of how to retrieve/scrape website data using MSXML and HTMLDocument but not using the InternetExplorer Application Object. The problem with the InternetExplorer.Application object I have a few blog entries demonstrating how to get web site data using InternetExplorer and the HTMLDocument object. However, there are a few problems with this: Microsoft is […]
Continue readingQuickbooks SDK iAddCheck using VBA. Add a check from Excel or Access
Someone reading my part 1 of ??? tutorial on Quickbooks – sorry.. read the notes. 😉 – was struggling to find how to add checks. I wrote them this morning about what to look for in the On Screen Reference OSR for the Quickbooks SDK. iCheckAdd Under the Onscreen Reference, there is a iCheckAdd message. […]
Continue readingGet Multiple Distances Using the Google Maps API and VBA for Excel or Access includes sample file
UPDATE 5/1/2019 I’ve updated this tool. To download the updated sheet visit this new blog entry. Or click the image below. … Recently, a client wanted a market analysis showing how far customers traveled to get to their location. They were having employees manually check addresses using Google maps to determine this information and entering […]
Continue readingRetrieve Data from Website in Microsoft Access or Excel using VBA
File Download: Microsoft Access/VBA Sample File Edit: 7/23/2017 – an improvement to this solution. This will require some refactoring. A week or so ago a reader asked (on this blog post), if we could place the file online that performs the operation in this blog post (and video). I’ve included it below as a download. The […]
Continue readingConnecting Microsoft Access and Quickbooks using the Quickbooks SDK part 1 of 3
Aging Post Note: I considered taking this down. At this point, I’m not writing the series. I am busy with a myriad of projects – both programming and in other areas (see my music/writing blog). However, I will publish some VBA SDK code as more or less stand-alone blog entries. I’ll categorize them under the […]
Continue readingGoogle adds voice to text to Google Docs
Google Drive/Docs = Amazing! First, let me say it again. If you are NOT using Google Drive/Google Docs, you need to start immediately! A few weeks ago I demonstrated how you can use your Android voice-to-text to dictate into a Google Document. That’s great technology for note-taking and even longer documents. Now Google has introduced […]
Continue readingMailmerge without using Microsoft Outlook uses only Excel, VBA, Word, and CDOSys
Summary: Send personalized emails to a list of email addresses and names in Microsoft Excel. Technologies used Microsoft Excel Microsoft Word VBA (Visual-basic for Applications) CDOsys (Collaboration Data Objects for Windows 2000) CDOSys Documentation It’s amazing how poorly documented it is.. but this link has some answers. https://msdn.microsoft.com/en-us/library/ms526318(v=exchg.10).aspx And Dan at Microsoft has several links: […]
Continue readingSpeech to Text for Google Docs using your Android Smart Phone
Mobility, Productivity, and Creativity The other day I was scripting a podcast episode. I’ve used speech to text with Windows 7 in Microsoft Word and it works pretty well. But most of my scripts are collaborative and my team and I use Google Docs extensively. I’ve tried some of the speech to text plug-ins for Chrome […]
Continue readingVideo: Is LinkedIn an Effective Social Network
In this short (2:55) video clip, Pulse founder, Matt Moran, answers a question about LinkedIn as a social platform and provides some insight on how to use that network, and others, for true engagement. Also, a little about the “Like my page and I’ll like yours” phenomenon. Using LinkedIn More Effectively Some tips and the clip […]
Continue reading3 Ways to Make Your Company Network Faster TODAY!
The Real Problem: Part 1 – Getting Back to Basics So many clients believe that they need to upgrade all kinds of equipment, including every desktop computer, in order to regain the speed they remember enjoying earlier on. All in the name of “Investing in Communications” or “Improving our Business Infrastructure.” The truth is hardware […]
Continue readingUsing Smartsheet as Your Social Media Content Calendar
We use Google Calendar and shared documents and folders on Google Drive to help manage our content and that of our clients. But, one of the most interesting and powerful tools we’ve put into place as a Content Calendar, is Smartsheet. We’ve tested many content calendars – basic spreadsheets to collaborative systems. In doing so, we realized […]
Continue readingShare the Correct Blog Image on Facebook from WordPress
If you use WordPress and share your content on Facebook, this should interest you. This blog entry will teach you how to ensure the right image, title, and description shows up when your blog or webpage is shared on Facebook. We’ll be covering: Optimal image size How/where to create your image for free How to […]
Continue readingLinkedIn – A Tale of Two Interactions
It was the best of conversations. It was the worst of conversations. – thanks Dan for the intro I’ve written about LinkedIn effectiveness before, but a couple of weeks ago I had two interactions in a single day that exemplified what I have been talking about and advocating for the past couple of years. The […]
Continue readingMaking your email newsletter mobile friendly and attractive with MailChimp
Recently, I sent out a newsletter and was dismayed to discover that MS Outlook had rendered it horrifically! It was AFTER I’d sent it – so I was mortified and a bit frustrated. I posted a snide comment on Facebook and then tweeted an image of that snide comment.. And on Facebook #Microsoft @Microsoft Fix […]
Continue readingTeam Collaboration and the Inefficiency of Email
At Pulse, we’ve adopted Glip.com as our internal project communication tool… and it is AMAZING!!! “a single email about a project can result in dozens of responses.. email clutter” Have you seen/experienced this at your organization? Someone sends an email to several (let’s say 5) recipients asking for feedback on some tasks or document. 4 […]
Continue reading