Cory Posted April 16, 2008 Report Share Posted April 16, 2008 I just created this web page tutorial to demonstrate how to drive a macro from a text file instead of an application and more importantly how to accumulate the results in TSV format for ease of integration and speed. Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted April 17, 2008 Report Share Posted April 17, 2008 Hi cory, checked your example. Maybe i am wrong but it does not display the results. It shows only the original data but not the square roots. u have the copied the results to t2 and then appended it to t3 (along with t1). saved it to text file and clipboard. the text file for display only shows t1 and when i try using the clipboard in excel no data shows up. ???? Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted April 17, 2008 Report Share Posted April 17, 2008 HI cory, sorry for the earlier post. I had to change few thins like the location of the source file etc.. and it works fine. Quote Link to comment Share on other sites More sharing options...
balithag Posted April 18, 2008 Report Share Posted April 18, 2008 Hi, Cory, I had been using some of the techniques in your tutorial, but reading through it fleshed out some things for me and taught me some new things too. Thanks. Quote Link to comment Share on other sites More sharing options...
Cory Posted April 18, 2008 Author Report Share Posted April 18, 2008 My pleasure. I should have done it long ago as I keep talking about it over and over here but sometimes the abstract just doesn't cut it. Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted April 23, 2008 Report Share Posted April 23, 2008 HI cory, your tsv files is working exceedingly good and thanks a lot!. I have an issue here. As you already know i am running for around 5-10hrs the macro which repeats in the loop and it saves to the file only when it completes. Now if my system gets hanged due to some reasons or it gets stuck then i have no data that is saved and i have to repeat the entire process again which is wasting lot of time. i have read the one post which u said to use breaks but i am bit confused. Can we see something like it saves the data that is processed to the file after let us say 30min and then runs and adds to the one it is saved after another 30min. Advise please Quote Link to comment Share on other sites More sharing options...
Cory Posted April 23, 2008 Author Report Share Posted April 23, 2008 Meh... you can figure that out. But if it's possible to have an interruption you should instead output a record for each iteration. This is often the safe bet. Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted April 25, 2008 Report Share Posted April 25, 2008 Meh... you can figure that out. But if it's possible to have an interruption you should instead output a record for each iteration. This is often the safe bet. sorry but i had it done. As soon as i put this post i tried saving the file after each iteration though to a diff name.txt. it did work wonderfully. now even if my macro stops or somehting goes wrong i will have the data till the time it is processed. JUst adding to that we can also i think save the output directly to an excel sheet. i will be trying it now to see if it happens without any erros. it wuld save a lot of time and rework. Anyhow it helped me a lot! Quote Link to comment Share on other sites More sharing options...
Cory Posted April 25, 2008 Author Report Share Posted April 25, 2008 Saving to excel will require you interact with the program and this increases the risk of problems. Excel natively understands TSV so all you need to do is open the results file with Excel. What could be easier? But if you do want to take this route create an entire row in the variable and paste the whole things all at once. Excel knows what to do with TSV because that's it's native interchange format for the clipboard. Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted April 29, 2008 Report Share Posted April 29, 2008 sorry for the delay in replying. was stuck with a project. I think what you suggested makes sense. will try and let u know Quote Link to comment Share on other sites More sharing options...
sunilvedula Posted April 30, 2008 Report Share Posted April 30, 2008 hi cory., was unable to locate the attachement in the mail sent to you. i am forwarding the attachement. Can we copy all the data from the excel and process each row at a time. is it possible using the concept of tsv or anything else. it is not allowing to upload as it says not allowed to upload this type of file . account no udf no trans amt trandt financharge account secure overlimit fees 123456789 451245 150 March 24, 2008 0.25 2 30 Quote Link to comment Share on other sites More sharing options...
Cory Posted April 30, 2008 Author Report Share Posted April 30, 2008 I sent you a reply to your PM but for th benefit of others the solution is to create a temp TSV file and use ASCII File Process. Quote Link to comment Share on other sites More sharing options...
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.