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.
Continue Reading: Hands Off That Email Attachment! »
Automated Word Mail Merge from Excel
Greetings,
I just updated the site with some code for automating the mail merge to Word process. Check it out here:
Enjoy,
JP
HTML Object Libraries
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.
Continue Reading: HTML Object Libraries »
Check Access table(s) from Excel using Automation – Updated Code
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 increase over yesterday's code is significant.
Continue Reading: Check Access table(s) from Excel using Automation – Updated Code »
Check Access table(s) from Excel using Automation
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.
Continue Reading: Check Access table(s) from Excel using Automation »
Follow Me