How to connect to OPEN workbook in another instance of Excel SAP Issue

[Radoslaw Poprawski]

I tried to follow up with the topic here: How to connect to OPEN workbook in another instance of Excel
And yes I also posted this question on stack:

How to connect to OPEN workbook in another instance of Excel SAP Issue

I tried to follow up with the topic here: How to connect to OPEN workbook in another instance of Excel But I ran into a problem, Iam not able grab the new instance name or path However I know I hav...

stackoverflow.com

But I ran into a problem, Iam not able grab the new instance name or path
However I know I have open excel window in another instance (opened from SAP system) and when I open VBA editor in that SAP generated excel file and I type: ? Thisworkbook.Path in immidiate window I get nothing, no path is given and thus this solutions does not get the instance path.
What can I do make it work ?
My issue is that this: Set xlApp = GetObject("C:\Tmp\TestData2.xlsx") is not grabbing the workbook name (including This.workbook.name or activeworkbook.name)
Any idea how else I can work in instance 1 vba code with workbook in instance 2?
I only want to save it nothing more, im using SAveas option, or at least I try. Did any1 had similiar issue?

 

[Radoslaw Poprawski]

up

 

[Jaafar Tribak]

It sounds as if excel instances generated by SAP do not get registered in the Running Object Table.
What is the name of the workbook that is generated by the SAP software? And is the window of the generated excel workbook a child of the SAP application ?

 

[Radoslaw Poprawski]

Hi,
thanks for repling.
the name is simple "Book1" and the "1" usualy is a different number.
I did not manage to understand when the number changes.
the Excel file is a result from a custom created T-code to which I do not know how it programmed.
However i think that yes, the file is SAP chiald since it came out of SAP NOT using normal data extraction path.