It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,011
×10,960

question asked: Jul 20 '12, 5:49 a.m.
question was seen: 5,098 times
last updated: Nov 06 '16, 9:55 p.m.

Related questions

Attach an image in TCER in excel

0
Shivanand Divekar (6●2●11●12) | asked Jul 20 '12, 5:49 a.m.


Hi,

I am using RQM Excel imort export utility (RQM 4.0 RC5 version) to import test execution records from RQM. I have imported .RQMS file in excel. I want to attach an image file in Actual Results column. AS mentioned in online help on RQM, I am trying to attach an image. But, Insert --> Picture menu in excel is disabled and not getting enabled for any cell.
Please let me know if I am missing anything.

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Hao Wan (1.5k●3●5) | answered Jul 22 '12, 10:16 p.m.
JAZZ DEVELOPER
 Hi  Shivanand,
would you please have try the following steps.
in the excel that generated from import for offline, go to "Tools" -> "Protection" -> "Unprotect Sheet".
if require password, please have a try with "AAABBBABBAAn" case insensitive.

if the password is incorrect
please try to add a micro with the following content.

Sub PasswordBreaker()
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
    Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
    Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
    MsgBox "One usable password is " & Chr(i) & Chr(j) & _
    Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
    Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    ActiveWorkbook.Sheets(1).Select
    Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
    Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
    Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub
and run it to clear the protection of  worksheet.
0
permanent link
Paul Harrison (11) | answered Nov 06 '16, 9:55 p.m.
Thanks Shivand,
The password provided is correct in my instance (RQM 4.0.4).
Paul

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.