It's all about the answers!

Ask a question

Excel Importer: any changes for MS Office 2010 needed?

Judith Leick (8156) | asked Nov 20 '12, 12:03 p.m.

we have a cfg file which is working for my colleagues with MS Office 2003, but it's not working with MS Office 2010. Do we need to change the the parameters?

e.g. currently we have statements like this:

Do we need to change the config file to values like testscript.XLSXWorksheetID="Template"
testscript.XLSXStartRow=8 or something similar?


2 answers

permanent link
Jerry Shengulette (63914) | answered Nov 20 '12, 3:16 p.m.
I have been running MS Office 2010 for a while now with no specific issues. 

You might have to re-install the Interop assemblies; instructions here ( under "Add-in Installation" section.

Constructs such as you mentioned should still be OK.  How, exactly, is your new stuff not working?

Judith Leick commented Nov 21 '12, 4:41 a.m.

Hi Jerry,
we are getting the error message: "Invalid server name, user name or password". But the credentials are working fine for MS Office 2003.

permanent link
Hao Wan (1.5k35) | answered Nov 23 '12, 11:54 p.m.
Hi Judith,
I think no changes needed for office 2010
does the MS office 2003 and office 2010 installed on the same windows?
would you take a look at the MSO2RQM_debug.log, to see if it is a network problem and attach the log here?

Judith Leick commented Nov 27 '12, 7:53 a.m.

Hi Hao,

MS office 2003 and MS Office 2010 are installed on the same Windows/Laptop.
Here is the content of the logfile:
26.11.2012 14:04:13:
SESSION: 26.11.2012 14:04:12
26.11.2012 14:04:13: INFO: : RQMExporter created!
26.11.2012 14:04:13: INFO: : RQMExporter Startup!
26.11.2012 14:04:13: INFO: : Mso2Rqm: Mso2Rqm instantiated
26.11.2012 14:04:14: INFO: : ExcelApplicationContext: Destroyed commands
26.11.2012 14:04:14: INFO: : ExcelApplicationContext: Created commands
11/26/2012 2:05:38 PM: ERROR: : RQMConnector: Login - Error POSTing credentials to
11/26/2012 2:05:38 PM: EXCEPTION: : Object reference not set to an instance of an object.
11/26/2012 2:05:38 PM:    at Mso2Rqm_Common.RQMConnector.GetFromServer(String url)
   at Mso2Rqm_Common.RQMConnector.Login(String url, String username, String password)
11/26/2012 2:35:27 PM: INFO: : ExcelApplicationContext: Destroyed commands
11/26/2012 2:35:28 PM: INFO: : ExcelApplicationContext: Destroyed commands
11/26/2012 2:35:28 PM: INFO: : Mso2Rqm Shutdown!

I hope this helps....

Hao Wan commented Nov 28 '12, 3:00 a.m.

Hi Judith, please sure the user have the correct permission and license.
and you can restart the RQM server and have a try again.

Sam Leathem commented Feb 20 '13, 5:10 a.m.

Hi Hao,

I am having issues getting the Mso2Rqm installer to appear in Excel 2010 once it has "successfully" installed.  I have checked all pre requisites and still no luck.  Please advise.


Your answer

Register or to post your answer.