Getting excel file down to system tray when macro is running.

Hi All,
Am new to this group and stranger to vb scritping but i have manged to create (refering to several sources) a code to pull data from external site and create a report in excel and export all the charts to a pdf format. Report looks fine. I am tyring to get the excel file down to system tray when the macro is running. I have managed to get this minimized to taskbar when the macro is running but cannot get it down to system tray. Is it possible? Can anyone help me, please?

Originally Posted by TMShucks

Have a look at:

http://mvxl.blogspot.co.uk/2008/05/m...-tray.html?m=1


Regards, TMS

Hi TMShucks,
Thanks for your reply. I checked the url that you have shared and it looks great. However, it does minimize the userform to system tray, i believe. But i am looking for a code that will send an excel file down to system tray when i try to run a macro (macro is within that excel file) .

Can this code be modified to my need?

Please help.

Thanks
Ganesh

Originally Posted by TMShucks

An Excel "file" runs within Excel so I'm not entirely sure what you mean or what you want to achieve. If you run the file in its own instance of Excel, wouldn't minimising Excel to the System Tray be the same thing?

Regards, TMS

Hi TMShucks,
I agree that an excel instance, if minimized to system tray, will minimize all its files. But as i said, i am a stranger to vb scripting. I have a file named "abc.xlsm". i have added a code to this file so that whenever i double click this file, it automatically runs a macro within the file (minimized to task bar). Once it is done, a message pops ups and upon clicking "ok" entire excel application terminates ( i want it this way). It takes ~ a minute to complete this process. If i click the excel in the taskbar, then i am unable to do any other task until this macro completes.

So now, instead of minimizing it to task bar, i want it to go to sytem tray, so that i can do other tasks. Once i double click the file, it has to go down to system tray and do all procss and once completed it should show me a completion message. Is it possible to do it this way?

Can you please help me with the code?

Many Thanks

BR
Ganesh