After selecting imDEV as add-in, i get the runtime-error 5, illegal procedure call or in´valif argument. The debugger point to a statement
iHelpMenu = cbMainMenuBar.Controls("Help").Index in Sub make_imDEV_menue()
This happens with Excel2007 an imDEV 2007 as well as Excel2010 and imDEV 2010.
Installation of RExcel runs smooth and connection to RServer works.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried, but could not replicate your error with Excel 2010. So I'd like to know what may be different for you.
I am assuming you are using imDEV v1.2.1.
Have you ran any macros to change the generic menue layout in Excel 2007 or 2010?
Where does the RExcel menu end up?
Essentially, the error you are getting is in the code making the menu for imDEV. Specifically, an error occurs when trying to identify where the help menu item is. Its location is used to determine the placement of the imDEV menu for Excel 2003, but for 2007 and 2010 is mostly ignored as these force add-in menus to the add-in tab.
-Dmitry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
thanks for your answer. I installed the latest rexcel version via rexcelandfriends.exe. Its rexcel Version 3.2.1, R 2.14.0 and dcom 3.1-2b7. The rexcel menu ends ( last 4 entrys) with "RExcel Help", "R Help", "Demo Worksheets" and "About RExcel".
In excel2010 i made a primitive kludge and simply set iHelpMenu=4. No error message appeared and the imDev menu was available under add-ins. I could use imPCA. but then imCorr failed with the same set of data with an error message about incorrect data selection.
- Hubert
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am glad you figured out a work around for the menu!
For the next release I'll may implement a fix for this to make sure this problem won't occur for others as well.
As for imCorr, it is rather sensitive to missing values, and some other singular occurrence.
I'd be interested to know what specific analysis option caused an error for you?
One suggestions is to make sure that a correlation can be computed for the input data. You can check this by comparing the imPCA data object to the one that causes an error for imCorr. Get the imPCA data by selecting the "Return results" under the calculate menu, these will be returned to the "Complete data worsheet". This is the data that imPCA is actually working with, and for which all correlations can be calculated.
If this data is the same as the one you are using for imCorr then what ever error you are getting is coming from the R code, and may be a bug I need to fix.
If the two are different this may be due to too many missing values, non-numeric inputs, or some other error causing criteria. You may fix the problems with identified variables (for instance impute missing values) or just use the checked data for your calculations in imCorr.
-Dmitry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello, I got the same problem: "After selecting imDEV as add-in, i get the runtime-error 5, illegal procedure call or in´valif argument." But I cannot open the debugger because the project is protected. Could anyone help?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This seems to happen because the original location of the help menu may have been modified? I can't seem to replicate the error on my machines, but I'll try Implement a work around this. I'll post here when I do.
-Dmitry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I just uploaded a version (imDEV v 1.2.2.1 Excel 2007.rar) which may fix your specific error. I say "may" because it is bit hard to debug this problem as I can't reproduce it, but based on previous accounts it is related to where the imDEV menu is placed in Excel 2007 and 2010.
Please let me know if this fixes the problem ( and I'll add a 2010 fix the same way). If not, I will address this problem with an alternative fix for v1.3 (~ early March).
-Dmitry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Now ImDev is installed in Excel 2007, but several errors occur with R packages:
Here is a copy of the last messages:
Lade nötiges Paket: PreProcess
Attache Paket: ‘PreProcess’
The following object(s) are masked from ‘package:ellipse’:
ellipse
The following object(s) are masked from ‘package:car’:
ellipse
Lade nötiges Paket: fastICA
Lade nötiges Paket: qvalue
Lade Tcl/Tk Interface … fertig
Lade nötiges Paket: Fselector
Installing package(s) into ‘C:/Users/Bernd/AppData/Roaming/Microsoft/AddIns/imDEV v 1.2.2.1 Excel 2007/library’
(as ‘lib’ is unspecified)
-- Please select a CRAN mirror for use in this session --
Lade nötiges Paket: Fselector
The following packages could not be installed:
Fselector
Please manually install these.
>
- Bernd
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Don't worry about the masked functions, that is normal. This happens because the various packages use the same names for their functions. This won't affect anything.
Not having FSelector installed will affect the imPLS feature selection module. You can try changing your cran mirror and reinstalling it. Or get the zip file (http://cran.r-project.org/web/packages/FSelector/index.html) and choose to install from zip option.
-Dmitry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After selecting imDEV as add-in, i get the runtime-error 5, illegal procedure call or in´valif argument. The debugger point to a statement
iHelpMenu = cbMainMenuBar.Controls("Help").Index in Sub make_imDEV_menue()
This happens with Excel2007 an imDEV 2007 as well as Excel2010 and imDEV 2010.
Installation of RExcel runs smooth and connection to RServer works.
Hello,
I tried, but could not replicate your error with Excel 2010. So I'd like to know what may be different for you.
I am assuming you are using imDEV v1.2.1.
Have you ran any macros to change the generic menue layout in Excel 2007 or 2010?
Where does the RExcel menu end up?
Essentially, the error you are getting is in the code making the menu for imDEV. Specifically, an error occurs when trying to identify where the help menu item is. Its location is used to determine the placement of the imDEV menu for Excel 2003, but for 2007 and 2010 is mostly ignored as these force add-in menus to the add-in tab.
-Dmitry
Hello,
thanks for your answer. I installed the latest rexcel version via rexcelandfriends.exe. Its rexcel Version 3.2.1, R 2.14.0 and dcom 3.1-2b7. The rexcel menu ends ( last 4 entrys) with "RExcel Help", "R Help", "Demo Worksheets" and "About RExcel".
In excel2010 i made a primitive kludge and simply set iHelpMenu=4. No error message appeared and the imDev menu was available under add-ins. I could use imPCA. but then imCorr failed with the same set of data with an error message about incorrect data selection.
- Hubert
Hi,
I am glad you figured out a work around for the menu!
For the next release I'll may implement a fix for this to make sure this problem won't occur for others as well.
As for imCorr, it is rather sensitive to missing values, and some other singular occurrence.
I'd be interested to know what specific analysis option caused an error for you?
One suggestions is to make sure that a correlation can be computed for the input data. You can check this by comparing the imPCA data object to the one that causes an error for imCorr. Get the imPCA data by selecting the "Return results" under the calculate menu, these will be returned to the "Complete data worsheet". This is the data that imPCA is actually working with, and for which all correlations can be calculated.
If this data is the same as the one you are using for imCorr then what ever error you are getting is coming from the R code, and may be a bug I need to fix.
If the two are different this may be due to too many missing values, non-numeric inputs, or some other error causing criteria. You may fix the problems with identified variables (for instance impute missing values) or just use the checked data for your calculations in imCorr.
-Dmitry
Hello, I got the same problem: "After selecting imDEV as add-in, i get the runtime-error 5, illegal procedure call or in´valif argument." But I cannot open the debugger because the project is protected. Could anyone help?
Hello,
This seems to happen because the original location of the help menu may have been modified? I can't seem to replicate the error on my machines, but I'll try Implement a work around this. I'll post here when I do.
-Dmitry
Hi,
I just uploaded a version (imDEV v 1.2.2.1 Excel 2007.rar) which may fix your specific error. I say "may" because it is bit hard to debug this problem as I can't reproduce it, but based on previous accounts it is related to where the imDEV menu is placed in Excel 2007 and 2010.
Please let me know if this fixes the problem ( and I'll add a 2010 fix the same way). If not, I will address this problem with an alternative fix for v1.3 (~ early March).
-Dmitry
Hi Dmitry,
thanks for quick fixing.
Now ImDev is installed in Excel 2007, but several errors occur with R packages:
Here is a copy of the last messages:
Lade nötiges Paket: PreProcess
Attache Paket: ‘PreProcess’
The following object(s) are masked from ‘package:ellipse’:
ellipse
The following object(s) are masked from ‘package:car’:
ellipse
Lade nötiges Paket: fastICA
Lade nötiges Paket: qvalue
Lade Tcl/Tk Interface … fertig
Lade nötiges Paket: Fselector
Installing package(s) into ‘C:/Users/Bernd/AppData/Roaming/Microsoft/AddIns/imDEV v 1.2.2.1 Excel 2007/library’
(as ‘lib’ is unspecified)
-- Please select a CRAN mirror for use in this session --
Lade nötiges Paket: Fselector
The following packages could not be installed:
Fselector
Please manually install these.
>
- Bernd
Hi,
Don't worry about the masked functions, that is normal. This happens because the various packages use the same names for their functions. This won't affect anything.
Not having FSelector installed will affect the imPLS feature selection module. You can try changing your cran mirror and reinstalling it. Or get the zip file (http://cran.r-project.org/web/packages/FSelector/index.html) and choose to install from zip option.
-Dmitry