when i ran the macro given by you it should only give a msg in the msg box that plz download the xyz file plz help me in the same i need a macro to do same by vba