Tuesday, May 13th, 2008 113 views
Here is the finished code for the Outlook File Request System.File Server CodeThis is event code which acts as an automated file server, putting files into the specified folder, and sending files back to the requestor, all via email. Once the code is installed, another user requests a file from ...
Posted in Outlook, VBA, automation | No Comments »
Tuesday, April 29th, 2008 71 views
One of the most popular pages on this site shows code for automating Internet Explorer. However I have only tested the code in Excel XP/2003. The purpose of this post is to credit a gentleman named Durand Sinclair who, using Excel 2007, pointed out to me that the name of ...
Posted in Excel, Internet Explorer, VBA, automation | 2 Comments »
Sunday, April 27th, 2008 48 views
Here is the event code I promised for forwarding emails to another email address. It does exactly the same thing as the previous code, but since it is event code, once you place it in a class module and restart Outlook, it runs automatically without any need for you to ...
Posted in Outlook, VBA, automation | 2 Comments »
Monday, April 14th, 2008 121 views
About halfway down the Outlook page, there is some VBA code for opening an Excel workbook attached to an email, running a macro on it, then cleaning up and moving the email to another folder.
Here is some more sample code to make your macro even more intelligent. This code opens ...
Posted in Excel, Outlook, VBA, automation | No Comments »
Saturday, March 29th, 2008 131 views
Greetings,
I just updated the site with some code for automating the mail merge to Word process. Check it out here:
Excel Mail Merge
Enjoy,
JP
Posted in Excel, VBA, Word, automation | No Comments »
Wednesday, February 20th, 2008 50 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 »
Thursday, January 31st, 2008 10 views
Here is the revised and completed code that I posted yesterday. The DAO declarations are moved outside the Sub procedure and the 'Set' statements are outside the function loop. Also, the table & column headers are now passed as arguments to the function, making the code more compact. The speed ...
Posted in Access, Excel, VBA | No Comments »
Wednesday, January 30th, 2008 32 views
Finally, with some help from the good folks over in the microsoft.public.access.modulesdaovba newsgroup, I was able to complete my code to search an Access database for some information stored in an Excel worksheet.
This code will cycle through a list of numbers in column B, starting in cell B2, then check ...
Posted in Access, Excel, VBA | No Comments »
