How to get instance Excel2016?
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.
Code:
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
Code:
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,...
Code:
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!
Re: How to get instance Excel2016?
hi, am i using it the wrong way? ( this code runs normally if i open excel2010 instead of excel2016.)
I think this must work.
Code:
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!
Re: How to get instance Excel2016?
Quote:
Originally Posted by
Dang.D.Khanh
I use the following
code to get the running excel instance ...
I don't know what is the purpose of
Code:
for (int j = 1; j <= 5; j++)
It is very clear states in the comments to the code:
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);
}
Quote:
Originally Posted by
Dang.D.Khanh
Although when I run the code, I always get pDisp!=nullptr but I can't query to workbooks from m_XLApp,...
Code:
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?
Re: How to get instance Excel2016?
Quote:
Originally Posted by
Dang.D.Khanh
...
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?
Re: How to get instance Excel2016?
The path for excel10 and excel16 will be different. You need to find the installed paths for your system and use them as appropriate.
3 Attachment(s)
Re: How to get instance Excel2016?
Hi Sir,
Code:
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
Attachment 35977
-----------------------------------------------------------------------------------_result value
Attachment 35978
-----------------------------------------------------------------------------------_then I get error
Attachment 35976
Re: How to get instance Excel2016?
Quote:
Originally Posted by
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.
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?
Re: How to get instance Excel2016?
The installed path for Excel can be obtained from the registry:
HKLM\Software\Microsoft\Windows\CurrentVersion\App Paths\Excel.exe\path
Re: How to get instance Excel2016?
Quote:
Originally Posted by
Dang.D.Khanh
Hi Sir,
HTML Code:
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?
Re: How to get instance Excel2016?
Quote:
Originally Posted by
2kaud
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. :o
Re: How to get instance Excel2016?
Quote:
Originally Posted by
VictorN
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.
Re: How to get instance Excel2016?
Quote:
Originally Posted by
Dang.D.Khanh
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.
3 Attachment(s)
Re: How to get instance Excel2016?
Quote:
Originally Posted by
VictorN
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.
Attachment 35982
Attachment 35983
Attachment 35984
Re: How to get instance Excel2016?
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
Re: How to get instance Excel2016?
Quote:
Originally Posted by
VictorN
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!
Re: How to get instance Excel2016?
Quote:
Originally Posted by
Dang.D.Khanh
Hi Sir,
After a while to edit registry without any experience ,
Finally, I ended up by reistall both office to get them to work. :cry:
This is exactly what I expected !
So, does it work now?
Re: How to get instance Excel2016?
Quote:
Originally Posted by
VictorN
So, does it work now?
Hi Sir,
i don't know to have 2 pages now.
yes, it's working fine.
Re: How to get instance Excel2016?
Quote:
Originally Posted by
Dang.D.Khanh
Hi Sir,
i don't know to have 2 pages now.
yes, it's working fine.
What do you mean by "to have 2 pages"?
Re: How to get instance Excel2016?
Quote:
Originally Posted by
VictorN
What do you mean by "to have 2 pages"?
Hi Sir,
I mean I don't know my post has 2 pages :d ,
so I was a bit slow to respond.
