Archive for February, 2008
Wednesday, February 27th, 2008 307 views
I recently posted links to the HTML and Internet Explorer object references. These are excellent tools to get web data into MS Office for further processing.
Lately I have been reading into XML as it appears to be a much faster way to access web pages than instantiating Internet Explorer. My ...
Posted in Excel, Internet Explorer, VBA, automation | No Comments »
Tuesday, February 26th, 2008 14 views
I just posted some new code on the Outlook page which demonstrates how to automate the "Resend This Message..." functionality which is found on the Actions menu of an opened Sent email.
Along with the code I've also posted brief instructions on how to add a macro to a toolbar button ...
Posted in Outlook, VBA | No Comments »
Wednesday, February 20th, 2008 89 views
As part of my code section on automating Internet Explorer, here are the links to the object libraries being used. Very useful, I recommend experimentation to find the right way to access whatever website you are trying to integrate with.
DHTML Object Reference
Internetexplorer Object Reference
I was not able to find a ...
Posted in Excel, Internet Explorer, VBA, automation | No Comments »
Wednesday, February 20th, 2008 113 views
Here is an update to the code I have posted on the site at
Format SSN
I realized that the last part of the formula doesn't check for dashes. Here is the updated formula:
=IF(AND(LEN(A4)>6, LEN(A4)9, NOT(ISERROR(FIND("-",A4)))),A4,LEFT(A4,3)&"-"&MID(A4,4,2)&"-"&RIGHT(A4,4)))
Notice the addition of NOT(ISERROR(FIND("-",A4))) in the second IF formula.
If the formula already has dashes in it, ...
Posted in Excel, Formulas | No Comments »
Monday, February 4th, 2008 590 views
Back in January, I promised to post a macro that imports data from Excel into Access programmatically.
(See My First Access Macro.)
It takes a given spreadsheet and imports it into a given Access file/table. The spreadsheet must have a header row, with no blank rows or columns inside the table block. ...
Posted in Access, Excel, VBA, automation | No Comments »
