LeanneBlakemore1972
New Member
- Joined
- Apr 15, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi. I have an external application that pushes data into a designated excel without first opening that excel (it must be closed or the data does not push over). The excel has a small macro in it that recognizes when data has been moved into a certain cell and then moves it into the location in a new sheet that I have designated. This works if I manually populate the cells, but not when the external application pushes the data over. I assume this is because it is not actually opening the excel workbook. There are no features in the external application that can trigger this or open the file before data is pushed over. Is there are way to make a closed excel run that macro when the data is received?