Basically, I have written a VBA app that calls upon Excel, and opens Excel, then opens a workbook, and then makes a few modifications, and then saves and closes that workbook.
What I cant seem to figure out is how to determine if the user has any other workbooks open before the VBA app attempts to shut down Excel.
I have found example for a specific workbook, but I will not know what workbook a user night have open. I just want a check tool.
Thanks for the guidance,