Importing Tips and Tricks

Hi, 
I'm trying to make a script wait a certain amount of time before continuing. The reason is to wait for it to completely send the email with the excel files and then delete the folder containing the files.
 

Hello,
I am looking for an IDEA Script that will automate the importing of multiple Excel files in the same folder, each file has multiple tabs with different name for each tab. Ideally, the script will also add the file name, and the Tab name as well to each imported file, then append all the imported files into one .IMD file.
if you can reach me by email, I will really appreciate it: emad.alphonse@irs.gov

Does anyone have any helpful tips on how to import information from a report as depicted in this post? There is a line of information defining the G/L account number, name and overall balance information, then another "subheader" line, if that's what you would call it, before it goes into the actual activity detail for the account. 

Hi,
We have to import many XML files via IDEA script. The problem is that using macros we have to have a XRDF file which does not exist and is usually created by the import dialog.
Is there a way to automatically create the XRDF file so we can use the XML import in a macro?
Cheers
Peter

Hi there!
I am trying to import data containing Chinese Characters into IDEA, however it shows error:
'The imported file contained Unicode characters. All imported Unicode characters have been replaced with the question mark character (?).' 
 
Can I know how to import Chinese Characters into IDEA? Thanks in advance!

Sometimes in Excel (and other databases) you will come across a field that contains both the date and time information such as: 2014-05-05  12:00:00 PM

If you bring in this field using the regular Excel import you will only capture the date portion of the field and the time portion gets dropped.