Jump to content
Macro Express Forums

Recommended Posts

Posted

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.

Posted

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. ????

Posted

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.

Posted

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

Posted

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.

Posted
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!

Posted

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.

Posted

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

Posted

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...