paramesium Posted June 12, 2009 Report Share Posted June 12, 2009 Hi everyone, I hope i can make the data i got in labview to be transfer into excel and make a graph and so i did a VI with activex. But it seems like something wrong with my programme because theres an error message coming out everytime i run the vi although i can get the graph in excel run time error '1004': Delete method of series class failed Quote Link to comment
dblk22vball Posted June 12, 2009 Report Share Posted June 12, 2009 Can you post your code?? It is hard to determine what the problem is without seeing the code, specially with activeX and excel. Quote Link to comment
asbo Posted June 12, 2009 Report Share Posted June 12, 2009 Based on the VIs you're using, I'd wager the error is coming out of your macro. Post the post for that as well. Quote Link to comment
paramesium Posted June 12, 2009 Author Report Share Posted June 12, 2009 ok... heres the link VI http://h1.ripway.com/paramesium/Untitled%203.rar excel file http://h1.ripway.com/paramesium/project.xls (something wrong wif my comp.. i cnt upload it through lava.. i am sorry) Quote Link to comment
dblk22vball Posted June 12, 2009 Report Share Posted June 12, 2009 I got the main VI, but none of the sub-vis, aka all of your excel vi's Macro- It runs fine for me, with no errors, so it is probably something that is being called out of order or a wrong pointer in your excel vi's Quote Link to comment
paramesium Posted June 12, 2009 Author Report Share Posted June 12, 2009 oops here the sub VIs.. hope you dont mind to help me check again >< http://h1.ripway.com/paramesium/subs.rar p/s: most of the sub VIs can be found from excel.llb, those that cnt be found is in special.llb Quote Link to comment
dblk22vball Posted June 12, 2009 Report Share Posted June 12, 2009 I found your error, it is with inputting a 1D array. When you input the 1D array, there is no series 2 to delete (ie a second column), so it throws an error. If you input a 2D array (with data in both columns), it works fine. So you might be able to add a second column of dummy data to the 1D array and then it will be deleted or you could do some more coding to determine the range to graph (if it is a 1D, then only graph column 1) Quote Link to comment
paramesium Posted June 12, 2009 Author Report Share Posted June 12, 2009 ok... i got what u mean .. thanks a lot... Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.