I'm trying to export data using a macro into either notepad or .hol file. basically it's a calendar used by hundreds I'm trying to simplify the process of employees manually entering data from excel into outlook. I'd like to have the data that is filtered be transferred into a .hol file that they can just click on to have the calendar dates imported into outlook. I've got as far as creating the macro to filter all the data into the correct format for a .hol file but can't get excel to export it. I want to avoid having them use copy and paste into notepad and save it.