I need to reference a workbook that is open on the desktop, but the path is unknown. Is there anyway to use the GetObject to reference a workbook based on it's name instead of the full path?
The macro can't do this by looking through the Workbooks collection because the open workbook is usually in a different instance of Excel from the one the macro is running from.
The macro can't do this by looking through the Workbooks collection because the open workbook is usually in a different instance of Excel from the one the macro is running from.