Hi everyone! I have just published a new tool today, Trusted Document Manager. This little tool enables you to manage your list of trusted documents. Currently, Excel only allows you to either leave the list intact, or delete the entire list. This means all of your currently trusted documents become...
Hi All, Microsoft announced today that the Help files for Office 2013 VBA have been made available for download. The help files are for: Access Excel Office Shared OneNote Outlook PowerPoint Publisher Word Visio Note that these files do not offer context sensitive help (F1), they are presented as stand...
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...
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...
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...
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...
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.
Dim ieApp As InternetExplorer...
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
Dim ieApp As Object
Dim ieDoc As Object
Dim Clip As DataObject
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
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...
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...
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...
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...
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...
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...