View Single Post
 
Old 12-13-2012, 10:54 PM
CatMan CatMan is offline Windows 7 32bit Office 2010 32bit
Intermediate
 
Join Date: Apr 2012
Posts: 39
CatMan is on a distinguished road
Default

Hi macropod, yes, I am using ShellExicute to send a URL to firefox, the url triggers some IT process that I have no control over, it sends data from a datamart and saves it to Excel in the downloads folder (the url does all that). The url does a good job (seems robust) of putting an excel file in the downloads folder so all I need to do is open it and copy the worksheet into the host Excel workbook. The host worksheet then has fresh data on which various macro's inside the host workbook operate on. I have all this working but I would like to clean up after the url exicutes, that is, close the firefox and downloads windows to make the process more transparent (and friendly) to the user.
Reply With Quote