General discussion

I am looking at automating scripts using 'Task Schedular" (Windows 7). I can get the script to open, but not run.
Can anyone help me out?
 
Regards
 
John

I have a problem copy selected range of cells from one excel workbook to another using IDEA
The following code sometimes works and sometimes does not. I cannot figure out what is wrong anf how to fix it.
BTW - Using seperate set of source and destination workbook and worksheet objects did not help.
 
any suggestion how to correct the code will be greatly appreciated. THANK YOU
 
Dim ex As Object 'Excel object
Dim wb As Object  'Excel Workbook
Dim ws As Object  'Excel Worksheet

Hi,I am relatively new to IDEAScripting and am having trouble extracting databases using "Start" and "End" dates which the user has input through a Dialog box. The user inputs MM/DD/YYYY as a string in a textbox and then I wanted to perform a database extraction with the "Transaction Date" being greater than the starting date and less than the ending dates.

After over a year I finally wrote a new blog post.  I need time to do more of these.  So this blog is about how to localize your script.  I would enjoy any comments you might have it.  You can find the link on the front page.

This slideshow shows the differences between using Excel and a Data Analytics Tool like IDEA.

https://www.slideshare.net/slideshow/embed_code/48485593

Hi there,
I would like to know whether IDEA could integrate with Ms.Outlook, example like, let say after I finish off my analysis and come out with the result, I could actually import it to the file that I wish to and finally integrate with my Outlook and send to my boss / team member for review.
I'm currently on v.9. Could it be happening via some script or have to wait for v.10?
Best regards, William.
 

Good day,
 
I would like to share my experience using Excel Multi-Select Dialog Box (MSDB) in IDEA.
First – some background. Probably the best places to learn how MSDB should work are here:
http://www.wiseowl.co.uk/blog/s209/type-filedialog.htm
and here: ( plus a useful example of how to use the File Dialog object)

The US General Accounting Office has just posted blog on big data that might be of interest to some users.

I just found this video on the business insider on Benford's law.  Gives some of the background on how it works.

There are a couple of new books out for IDEA.  One is "Fraud and Fraud Detection" by Sunder Gee who is one of my friends and a long-time IDEA user, trainer and consultant.  If you are having difficulty coming up with ways to use IDEA on your data you should pick-up a copy of the book as it will be a great help.