RQM Excel Importer Error "Can't open this location&quot

If I ignore the warning message about opening the location and continue with the export to repository I get the following error pop-up. I got this error originally but thought it was due to the location warning. A colleague was seeing the same warning "You can't open this location..." error but was able to successfully export to the repository (Win7 but with Excel 2007).

Error Dialog Box

RQM Export
Unhandled exception has occurred in a component in your application.
If you click Continue, the application will ignore this error and attempt to continue.

Exception from HRESULT: 0x800A03EC.


Details Dialog Box

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at Microsoft.Office.Interop.Excel._Worksheet.get_Range(Object Cell1, Object Cell2)
at Mso2Rqm_Common.ArtifactFactory.getVal(String sCurRow, Worksheet worksheet, Target target)
at Mso2Rqm_Common.ArtifactFactory.reduceCells(Target[] lines, Worksheet worksheet, String sCurrentRow)
at Mso2Rqm_Common.ArtifactFactory.reduce(Target line, Worksheet worksheet, String sCurrentRow)
at Mso2Rqm_Common.ArtifactFactory.getVal(String sCurRow, Worksheet worksheet, Target target)
at Mso2Rqm_Common.ArtifactFactory.createArtifacts(String configFile, Workbook workbook, String sProjectName)
at RQMExcelExporter.ExcelExportRepositoryDialog.handleExportToRepository(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

"You can't open this location using this program. Please try a different location."

I'm seeing this error when trying to use the RQM Excel Importer utility.

I'm running on Windows 7 (64 bit) with Excel 2003. I get this error after selecting 'Export to Repository' in Excel and "Choose the mapping file" Browse button.

I have tried reinstalling after ensuring that Windows updates are current and the Office Interop Assemblies are installed.

I can't find any other references to this problem but have to believe someone else has seen this.

Any advise is greatly appreciated.

Solved mystery. Found that the cfg file had category references that did not exist on this instance of RQM.

"You can't open this location using this program. Please try a different location."

I'm seeing this error when trying to use the RQM Excel Importer utility.

I'm running on Windows 7 (64 bit) with Excel 2003. I get this error after selecting 'Export to Repository' in Excel and "Choose the mapping file" Browse button.

I have tried reinstalling after ensuring that Windows updates are current and the Office Interop Assemblies are installed.

I can't find any other references to this problem but have to believe someone else has seen this.

Any advise is greatly appreciated.

Hey Michael,

I am a new RQM user and I was running into the exact same problem. I am running Windows 7 and Excel 2003. I was wondering what changes you had to make to the cfg file. Thank you in advance.

Ian Doolittle

Hi Ian,

I removed some lines like below that the RQM instance I was moving to did not have defined yet. The install samples I believe only use plain vanilla fields so those might be the best to start with.

HTH,

testcase.category term="FVT Scenario".value=G

Hey Michael,

I am a new RQM user and I was running into the exact same problem. I am running Windows 7 and Excel 2003. I was wondering what changes you had to make to the cfg file. Thank you in advance.

Ian Doolittle