Detecting Workbook created by another Application

[Koltack]

Hello Everyone,

I recently started working with Excel, and VBA for that matter.

I currently have an application that exports its data to a new excel sheet, And I would like to be able to click a button, Copy the data from the sheet I need, and paste it into my current workbook. I figured out how to take data from another workbook opened or created with excel, but am not able to see the workbook created by the export in my main workbook.

Is there a method to detect workbooks created or opened by another application?

 

[Fennek]

Hi,

mayby: in the attributes and the xml there are many information including the xl-version.

First use the win-explorer to check the file-attributes. If there is a valuable field, you can use the "namespace" to check this with vba.

Second: rename by hand the file to ".zip", open it in the win-explorer (NOT extract) and have a look to app.xml, core.xlm and workbook.xml. If there is meaningful information for you, it can be checked also with vba "namespace". If necessary use a search engine with "namespace unzip" and check the examples of a dutch "guru".

A feedback is appreciated.

regards

 

[Koltack]

Hi,

mayby: in the attributes and the xml there are many information including the xl-version.

First use the win-explorer to check the file-attributes. If there is a valuable field, you can use the "namespace" to check this with vba.

Second: rename by hand the file to ".zip", open it in the win-explorer (NOT extract) and have a look to app.xml, core.xlm and workbook.xml. If there is meaningful information for you, it can be checked also with vba "namespace". If necessary use a search engine with "namespace unzip" and check the examples of a dutch "guru".

A feedback is appreciated.

regards

At the moment the application creates a new excel sheet, but it is not saved anywhere, so I'm not sure of a way to see the file in win-explorer without saving it. If I save the document and reopen it am able to find the workbook perfectly, although id like to avoid this step, as My main purpose of this process is to perform a copy paste and this would take longer.

I would also like to mention that I am currently grabbing the last open workbook by using "Workbooks(Workbooks.Count)", and the count is not updated when the application creates a new workbook but is when existing one is opened from file explorer or created through excel. I am not able to find a way to add the application created excel to my main instances list

 

[Fennek]

Hi,

ok, now it beocomes a bit clearer: it seem the other application is creating a new instance of Excel. You can check this with Win-API's or with Word VBA and Tasks.

regards

 

[Jaafar Tribak]

At the moment the application creates a new excel sheet, but it is not saved anywhere, so I'm not sure of a way to see the file in win-explorer without saving it. If I save the document and reopen it am able to find the workbook perfectly, although id like to avoid this step, as My main purpose of this process is to perform a copy paste and this would take longer.

I would also like to mention that I am currently grabbing the last open workbook by using "Workbooks(Workbooks.Count)", and the count is not updated when the application creates a new workbook but is when existing one is opened from file explorer or created through excel. I am not able to find a way to add the application created excel to my main instances list

Are the other application and the workbook in it both created by your vba code ?