Working with Excel during export from Excel to QC
During excel export to QC(version 9.0) I am not able to work with Excel, Is this the limitation with QC/Excel, if so are there any possibility to work with excel during export.
Re: Working with Excel during export from Excel to QC
While doing the export, you are using an Excel macro. While that macro is running, you can't use the same instance of Excel. This means any dialogs that popup during the "setup" phase will also block you from using Excel.
You should be able to open a read-only copy of the same spreadsheet in a separate instance of Excel. You can then work with the spreadsheet in that 2nd instance, and work with your export macro in the 1st instance.
Hope this helps!