Run-time error '13': Type mismatch > excel report

HCL Domino Domino Forum
1

Dear Gurus,

I have an excel file (with VB coding in it) to generate a few reports, getting data from lotus notes database. If I open R5 client and then generate report from excel it works fine, but if R6 client is opened and if I generate report, I get this error “Run-time error ‘13’: Type mismatch”, and when debug, the code stops at line something like “a = Doc.Person_In_Charge”

The same excel file works with R5 but doesnt work with R6. Pls let me know if you have any solution or workaround for this problem. Thanks. John

2

Subject: Run-time error ‘13’: Type mismatch > excel report

what is the type of A ? because in you case you want to put array in A.

probably you declared A as string/number or initialized A as string or just number…

will check the type of A before “a = Doc.Person_In_Charge” string.

p.s. if A be variant, will try this syntax "a = Doc.GetItemValue(“Person_In_Charge”)

3

Subject: RE: Run-time error ‘13’: Type mismatch > excel report

ir try:

a = Doc.Person_In_Charge(0)

4

Subject: RE: Run-time error ‘13’: Type mismatch > excel report

Hi Guys,

Thanks for the response.

I tried both Doc.Person_In_Charge(0) and getitemvalue, but still the same problem…

fyi : all the code is in excel (VB)

Problem is only with R6, while the same code works fine with R5… may be need to update some dlls

Thanks.