When programe is trying to fetch data from qc i am getting error run time error 1004 Application error or excel error.
Please refer attached code for referenc.
When programe is trying to fetch data from qc i am getting error run time error 1004 Application error or excel error.
Please refer attached code for referenc.
Hi, welcome to the forum, the code tells me nothing.
I suggest a sample file with non-sensitive non-private data will do better
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hi Han,
I have attached my code, i will provide u some idea for code.
In first phase of code i am creating connection with my qc instance & authenticating the user who is loggin using this utility.
In second phase of code i am trying to fetch my release details & trying to fetch defects that are detected under that release.
For first phase it is working properly but when it start fetching defects from qc at that time excel throw me error 1004 & i am not able to resolve that
Aki
An Application defined error means that probably you forgot to dimension a variable
Is objworkbook defined somewhere?
Have you gone through the code step by step?
Try adding .Value
Please Login or Register to view this content.
Tried this but it saying "Object doesn't support this property or method" Runtime error 438.
More explanation please, on which line does this happen and have you checked if all variables are valid (dimensioned?)
I would need the file itself to troubleshoot. I'm sure it's a simple error but I cannot tell from your code.
Which file you require Han.. i have provided code other than that what else is required?
Well. just start thinking. How do you think I can reproduce anything if I do not know what the input is?
Your code is incomplete it begins with some irrelevant text and the first code line is On Error resume next.
I am quite good in writing VBA code and thinking up solutions but trying to guess what someones is working with or what the source data looks like, that is for magicians
Hi Han
I have attached code.
First, it's Hans not Han.
Second the code looks good but without data I cannot test anything.
So you will have to check yourself if all the worksheets you refer to exist and are present.
There is no error trapping, you just have a line that says Application.StatrusBar = Err.Description
Well, apart from that I cannot tell you anything
I have no idea what QC10 is and the 1004 error is that it is pointing to something that does not exist.
So what do you want me to do? Guess on things, do magic? It's your application, your data and all we get to see is code.
Sorry, you will have to be more explicit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks