Tag Archives: vba

Export Outlook From, To, Subject, Receive Date and other meta data into Excel

I had a need to export all the emails’ meta data like From, To, Subject, Receive Date from Outlook. Quickly searching on the internet, I found the script at http://superuser.com/questions/816289/exporting-attachment-file-name-email-metadata-from-outlook-to-excel so I quickly created a spreadsheet and exported all the needed information. I have made following modification to the code Commented out exporting email body… Read More »

Resolved: Method ‘Sheets’ of object ‘_Global’ failed

We have a complex macro enabled spreadsheet. Today we got a ticket from the business user that Excel is throwing error “Method ‘Sheets’ of object ‘_Global’ failed.”. I searched online but could not find the straight forward answer. None of the online discussion was giving the root cause of the error and everyone was discussing… Read More »

How to replace VBA code from Excel/Word

Have you ever had a situation where you wanted to replace the existing VBA code from Excel/Word and did not want to open up each file and change it? Well, remember that Excel and Word files are nothing but a zip file. You can easily create a program to replace the file from “zip” file.… Read More »

MS Access VBA: Get/set Javascript Variable in Microsoft Web Browser ActiveX Control

In your MS Access application, if you are using Microsoft Web browser, we may have to interact with the Javascript variable inside the loaded page. There is no obvious method exists in the Web browser control but using the following trick you can get/set the Javascript variable in the webpage. Quick Tip: Add Javascript function… Read More »

Change MS Access application title and icon using VBA

Here is a code to change MS Access application title and icon using VBA. This code also sets the application icon as form and report default icon. Dim db As Database Set db = CurrentDb db.Properties("AppIcon").Value = CurrentProject.Path & "\Bee.ico" db.Properties("AppTitle").Value = msgMainTitle db.Properties("UseAppIconForFrmRpt").Value = True Application.RefreshTitleBar Click here for list of all properties exposed… Read More »