Hi Experts,

I have a problem & looking for a macro that will do the below things

I downloaded an .xls file, as soon as file is downloaded it opens up automatically & I have file name macro1.xlsm & I need a macro that will close that .xls file by a macro (I will put the macro in macro1.xlsm & whenever I download that file & it will open automatically then I will open macro1.xlsm & I will run the macro & that file will be closed

Thnx for the Help

I am looking for a VBA macro & Yes I can do it manually but I will not do it manually(I have reasons for that)