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.
|