In Tip 824 Diane Poremsky shows us a bit of VBA that lets you add photos to your contacts in bulk. Let's try and improve the code.
Continue Reading: Add photos to Contacts in bulk using VBA in Outlook »
The site formerly known as Code For Excel and Outlook
In Tip 824 Diane Poremsky shows us a bit of VBA that lets you add photos to your contacts in bulk. Let's try and improve the code.
Continue Reading: Add photos to Contacts in bulk using VBA in Outlook »
In Import data to Access from Excel and My first Access macro, I posted some Access macros that push data into Access. Here is some code that does both.
Continue Reading: Pushing and Pulling Access around »
If you have a text file to import, but only need some of the data, you could just import the whole thing and then manually scrub the data to find what you want. Text files can contain a lot more lines than an Excel worksheet, but much of it may be fluff. Here's a method for importing only the data you need.
Continue Reading: Conditional Import Text Files »
Back in January, I promised to post a macro that imports data from Excel into Access programmatically.
Continue Reading: Import data to Access from Excel »
I wrote my first Access macro today! Now, I am not a big fan of Access, but unfortunately I have to use it at work because it is the first choice for most people looking for a db (short for "database") program. For most situations, I prefer Excel.
Continue Reading: My first Access macro »
Follow Me