Browse by Tags

Amazon Linkerator

Since I can’t install JPSoftwareTech’s Amazon link generator, I decided to write my own. Fewer features, less choice because that’s how I roll. I recommend JP’s version – it’s very well done. My tastes and habits are very quirky, so this “utility” is very specialized to the way I like to work. There may be [...] Read More...

Published Wed, Mar 03 2013 8:00 AM by Daily Dose of Excel

Filed under: Automation, Userforms and Controls

Do consumers prefer the ease of an EXE installer or the transparency of a ZIP file?

For all the various add-ins available from my website, I have supported two downloadable formats, an EXE and a ZIP file. The EXE is easier to install and includes an uninstall capability. The ZIP hopefully provides the consumer greater transparency and control over what is on their computer. In addition to the software downloadable from [...] Read More...

Published Tue, Nov 11 2012 8:00 AM by Daily Dose of Excel

Filed under: Add-ins, Automation, .Net, For Normal People

MSHTML Version and getElementsByClassName

Doug alerted me that Rob van Gelder’s In-Cell Charting post was yet another casualty of the great data loss of 2011. I got the post back up, but there were 85 comments on that post that really deserve to be put back. And I’m working on that. To that end, I wrote some code that [...] Read More...

Published Fri, Nov 11 2012 8:59 AM by Daily Dose of Excel

Filed under: Automation

Spot the 10 differences

Hi everyone! Yesterday I experienced the tedious task of figuring out what the differences are between the VBA projects of two different versions of a customer project I built a long time ago. Luckily there are tools to compare differences in text files, such as ExamDiff. But the VB editor doesn’t give you an easy way to [...] Read More...

Published Fri, Sep 09 2011 1:24 PM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Downloads, Automation, VBA Code Library, Excel Advanced

Waiting on Websites

On this post, Jan Karel Pieterse commented that I should put a timer in my wait code and I couldn’t agree more. It seemed like a good opportunity to just get that code out of the main procedure. Here’s what I came up with. Sub Gotosite() Dim ieApp As InternetExplorer [...] Read More...

Published Wed, Mar 03 2011 1:29 PM by Daily Dose of Excel

Filed under: Automation

Copying HTML Tables over Merged Cells

I ran into some strangeness while copying tables from the web to Excel. To demonstrate, I’ll use Debra’s sample data table. I run this code Sub GetTable() Dim ieApp As Object Dim ieDoc As Object Dim Clip As DataObject Set ieApp = CreateObject("InternetExplorer.Application") [...] Read More...

Published Thu, Feb 02 2011 2:15 PM by Daily Dose of Excel

Filed under: Automation

Dymo LabelWriter Part II

A couple of weeks ago, I posted some code to print labels on a Dymo LabelWriter 450. I wanted to post the finished code because it has a few more tricks in it. Function PrintBoardFileLabel(ws As Worksheet) As Boolean Dim bReturn As Boolean Dim vaPrinters As Variant Dim i As Long [...] Read More...

Published Tue, Aug 08 2010 7:30 AM by Daily Dose of Excel

Filed under: VBA, Automation, Printing

Printing to a DYMO LabelWriter 450 from VBA

I recently had to make some file folders at work. About five minutes after I was done, I purchased a DYMO LabelWriter 450. I was using one of those label makers where you punch in the text, hit print, and press down on a lever to cut the label. Then you have [...] Read More...

Published Tue, Aug 08 2010 7:30 AM by Daily Dose of Excel

Filed under: Automation, Printing

Saving Outlook Email and Attachments

Mike asks: I need code that will loop through each cell in a column and for each e-mail address search the inbox and save the e-mail and all attachments to a particular folder on a shared drive. Then I would require the saved files and attachments to be hyperlinked in to a cell in the row for [...] Read More...

Published Thu, Jul 07 2010 3:30 PM by Daily Dose of Excel

Filed under: VBA, Automation, Outlook

Performance of linked pictures

I frequently use the camera tool to create pictures linked to cell ranges. For example to be able to have different column widths beneath each other on one sheet. They have one major drawback however: they can slowdown VBA performance (when updating cells) enormously (update time may go up from .2 secs to as much as 8 [...] Read More...

Published Wed, May 05 2010 7:27 AM by Daily Dose of Excel

Filed under: VBA, MVP, Automation

Dynamic Columns in MS Query

Jeff commented that he wants to bring in the latest x columns in from spreadsheet using MS Query, where x is some number. The columns are expanding, so he doesn’t always know what the latest will be. I started with this example spreadsheet Note that the “date” headers aren’t really dates but strings (they have a [...] Read More...

Published Wed, Apr 04 2010 7:00 AM by Daily Dose of Excel

Filed under: Automation, Databases

Declaring API functions in 64 bit Office

Hi everyone, The release date of Office 2010 is closing in and with this new version we’ll have a new programming challenge. Office 2010 comes in a 32 bit and a 64 bit version. Especially API function declarations need to be adjusted for the 64 bit environment. We’ll have to change a declaration like this one: Private [...] Read More...

Published Thu, Jan 01 2010 12:14 PM by Daily Dose of Excel

Filed under: VBA, MVP, Automation, Windows API, Excel 14, Variables and Data Types

Starting multiple programs in MS Windows

While not Excel specific, I thought this would be useful to others. There are instances when I want to run a set of programs. One example is shortly after I log on to my computer when would like to start up MS Outlook, Firefox, IE 64bit, and Forte Agent. I wrote a VBS script, run through [...] Read More...

Published Sun, Nov 11 2009 4:00 PM by Daily Dose of Excel

Filed under: General, Automation

Reading XML Files in VBA

In Creating State Maps... I copied some data out of an XML file and graphed it into a state map. I wanted to try to read the XML file directly in VBA because I've never done it before. First, I set a reference to Microsoft XML v6. Six was the newest version [...] Read More...

Published Tue, Jun 06 2009 6:06 PM by Daily Dose of Excel

Filed under: Automation, Charting

Editing elements in an Excel OpenXML file using VBA

Hi Everyone! Today I finally found time to actually post a brand new article on my website. Wouldn’t it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article. Enjoy!! Regards, Jan Karel Pieterse www.jkp-ads.com Read More...

Published Wed, May 05 2009 1:13 PM by Daily Dose of Excel

Filed under: Excel12, Classes, VBA Advanced, MVP, Downloads, Automation, File Operations

Syndication

Recent Posts

Tags

News

Archives

Amazon Linkerator

Do consumers prefer the ease of an EXE installer or the transparency of a ZIP file?

MSHTML Version and getElementsByClassName

Spot the 10 differences

Waiting on Websites

Copying HTML Tables over Merged Cells

Dymo LabelWriter Part II

Printing to a DYMO LabelWriter 450 from VBA

Saving Outlook Email and Attachments

Performance of linked pictures

Dynamic Columns in MS Query

Declaring API functions in 64 bit Office

Starting multiple programs in MS Windows

Reading XML Files in VBA

Editing elements in an Excel OpenXML file using VBA