How to get instance Excel2016?

[Dang.D.Khanh]

Hi,
My computer is installing 2 versions of excel10 and excel16.
I use the following code to get the running excel instance but it only recognizes excel10.

    LPWSTR pszExcelPath = 
	  L"C:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE";

    CreateProcess(pszExcelPath, NULL, 0, 0, 1,
	  NORMAL_PRIORITY_CLASS, 0, NULL, &Start, &ProcInfo);

I don't know what is the purpose of

for (int j = 1; j <= 5; j++)

Although when I run the code, I always get pDisp!=nullptr but I can't query to workbooks from m_XLApp,...

m_XLApp.Attach(static_cast<Interface*> pDisp,true );
if (pUnk)
	pUnk->Release();
wstring s{ m_XLApp->Caption }; <<--vs crash then out debugging.

How I can fix this error?

Edited: There aren't multiple instances running at the same time, I just want to get at least one running instance.

Many thanks!

[Dang.D.Khanh]

hi, am i using it the wrong way? ( this code runs normally if i open excel2010 instead of excel2016.)
I think this must work.

Excel::_ApplicationPtr app(pDisp);
Excel::WorkbooksPtr ws = app->Workbooks;

what i mean is app will get instance of openning excel application and then i can access it properties.
however it always crash!

[VictorN]

I use the following code to get the running excel instance ...
I don't know what is the purpose of

for (int j = 1; j <= 5; j++)

It is very clear states in the comments to the code:

for(int i=1;i<=5;i++) //try attaching for up to 5 attempts
{
   HRESULT hr = GetActiveObject(clsid, NULL, (IUnknown**)&pUnk);
   if(SUCCEEDED(hr)) 
   {
       hr = pUnk->QueryInterface(IID_IDispatch, (void **)&pDisp);
       break;
   }
   ::Sleep(1000);
}

Although when I run the code, I always get pDisp!=nullptr but I can't query to workbooks from m_XLApp,...

m_XLApp.Attach(static_cast<Interface*> pDisp,true );
if (pUnk)
	pUnk->Release();
wstring s{ m_XLApp->Caption }; <<--vs crash then out debugging.

How I can fix this error?

Please, define ""crash".
Do you use try/catch blocks?
Is the m_XLApp pointer valid?

[VictorN]

...
what i mean is app will get instance of openning excel application and then i can access it properties.
however it always crash!

Please, define ""crash".
Do you use try/catch blocks?
Is the pDisp pointer valid? Is the app pointer valid?

[2kaud]

The path for excel10 and excel16 will be different. You need to find the installed paths for your system and use them as appropriate.

[Dang.D.Khanh]

Hi Sir,

	HRESULT hr = pUnk->QueryInterface(IID_IDispatch, (void**)&pDisp);
		
		if (SUCCEEDED(hr)) {
		    Excel::_ApplicationPtr app(pDisp);
		    Excel::_WorkbookPtr wb = app->ActiveWorkbook;  <<-- I get error at this code
		    CString s = wstring{ wb->Name }.c_str();
		    pUnk->Release();
		    ...
		}

in excel.tli:
Update Image:

-----------------------------------------------------------------------------------_my app value



-----------------------------------------------------------------------------------_result value



-----------------------------------------------------------------------------------_then I get error

[Dang.D.Khanh]

The path for excel10 and excel16 will be different. You need to find the installed paths for your system and use them as appropriate.

Hi Sir,
Can you explain more clearly? let's say if I run on another computer(client) it will probably be difficult for me.
Can I get the instance without specifying this?

[2kaud]

The installed path for Excel can be obtained from the registry:

HKLM\Software\Microsoft\Windows\CurrentVersion\App Paths\Excel.exe\path

[VictorN]

Hi Sir,

	HRESULT hr = pUnk->QueryInterface(IID_IDispatch, (void**)&pDisp);
		
		if (SUCCEEDED(hr)) {
		    Excel::_ApplicationPtr app(pDisp);
		    Excel::_WorkbookPtr wb = app->ActiveWorkbook;  <<-- I get error at this code
		    CString s = wstring{ wb->Name }.c_str();
		    pUnk->Release();
		    ...
		}

in excel.tli:


Attachment 35975

1. Your attachment doesn't open.
2. Please, use CODE tags rather than HTML ones.
3. What is the value of app?

[Dang.D.Khanh]

The installed path for Excel can be obtained from the registry:

HKLM\Software\Microsoft\Windows\CurrentVersion\App Paths\Excel.exe\path

Thanks sir,
Now this is clearer to me.
I remember that from this post I was able to access running excel entities and get the names of workbooks into a combobox (but it's in .Net).

Is there another approach that is simpler or has been explored in c++? because translating it is still beyond my ability.

Update: looks like I made a mistake. I tried to check again and it failed.

[Dang.D.Khanh]

1. Your attachment doesn't open.
2. Please, use CODE tags rather than HTML ones.
3. What is the value of app?

Hi Sir, I have updated that comment.
The error I get from this code:

if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));

The code works on excel 2010, but I can't continue on excel2016.

[VictorN]

Hi Sir, I have updated that comment.
The error I get from this code:

if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));

The code works on excel 2010, but I can't continue on excel2016.

You must catch the _com_error exception to obtain the reason of the problem!
See example in this thread.

[Dang.D.Khanh]

You must catch the _com_error exception to obtain the reason of the problem!

Hi Sir,
I followed your post and after run code, I get these error:

Exception thrown at 0x00007FF8AB5A9689 (KernelBase.dll) in sap.exe: 0x80029C4A: Error loading type library/DLL.

[VictorN]

You received the failure with hresult 0x80029c4a which means "Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)".
Possible reasons and workarounds are here: https://www.google.com/search?q=hres...hrome&ie=UTF-8

[Dang.D.Khanh]

You received the failure with hresult 0x80029c4a which means "Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)".
Possible reasons and workarounds are here: https://www.google.com/search?q=hres...hrome&ie=UTF-8

Hi Sir,
Maybe the problem occurs because I regularly clean my computer causing them to fail .
After reinstall my offices ,now it works fine .
This is exactly what I expected.
Thanks you!