Daily posts of Excel tips…and other stuff
Archive for the ‘Automation’ Category.
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 [...]
I have this macro that takes a long time to run. When it's done running, Excel become unresponsive and the Task Manager reports that Excel is using close to 100% of the CPU.
I just changed the macro recently so I know I screwed something up when I changed it. It turns [...]
Ginger comments:
The only thing I can’t do is to get XL to open the existing IE window so I can ’sendkeys’ to do that part. I can only see similar posts for “create.object” related to IE, and nothing for “get.object” (or whatever will work).
According to XtremeVBTalk, GetObject doesn't work with IE and you have to [...]
