Daily posts of Excel tips…and other stuff
Archive for the ‘Automation’ Category.
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 [...]
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 [...]
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 [...]
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
From Quickbooks, I can export any report directly into Excel. Quickbooks tries to maintain perfect fidelity between the report generated and what you get in Excel. An admirable goal, maybe, but here’s the result:
In this small piece of a physical inventory worksheet, you can see that columns A:D are all small. This [...]
In Outlook, I want to delete a folder if it has nothing in it. I don’t want to delete the built-in folders like Inbox, Outbox, Junk, etc., mostly because I get an error if I try. I couldn’t find a property of the MAPIFolder object that told me if it was a default [...]
Hi everyone,
With all these Euler posts I thought, why not post my own?
Suppose the following:
I have a products table set up like this:
Code ProdName Price
0001 Product1 556.68
0002 Product2 977.41
0003 Product3 350.62
0004 Product4 509.16
0005 Product5 748.4
0006 Product6 802.96
(list goes on to as much as 5000 products)
And I want to show this table in a userform and give the user some filtering possibilities (lets say on the first two [...]
Jorge Camoes discussed skyscraper bar charts. He writes:
Listen, unless you work for a statistics office, you should never create a chart like this. I know, it’s irresistible to check how well my state ranks, but identifying each and every data point in a virtually limitless bar chart makes no sense in most cases.
Does anyone [...]
