IDEAScript Questions

I am new to scritpting and have been utilizing history to create most of my scripts. I wanted to try and script to create a pivot table but unfortunatly when you create a pivot table there is no history to review. Is there a snippet or could someone share an example of how to create a pivot table in ideascript?

Hi, I am back once again. Have been working on the script and its been smooth with serveral ups and downs.
The current issue I am facing is that I cannot seem to store information within an object and I have the same error coming back to me each time.
My Dialog box's name is NewDialogX
sFieldName = listBox1$(NewDialogX.DialogBoxDropListBox2)
 
Error : Invalid Qualifier
If I were to remove NewDialogX the code runs but no information will be store in sFieldName.
p.s I ran a message box right after this.
 
Cheers!

Hi Brain, 
 
How are you doing? can you help me with a bit of script? I'm trying to get browse window to select a file. I already found a bit of script that lets you select a folder, but i need to select the file. I'm having problems converting the script to let me select a file instead of a folder.
 
Function BrowseFolder() Dim oFolder, oFolderItem Dim oPath, oShell, strPath, item Dim msg As String

Hi folks,
 
Hoping you can help as I'm struggling to get this script to run and being fairly new to scripting (I've only compiled a couple before), I was hoping to get some help on what I'm doing wrong.
 
I've attached the script I'm trying to run, which is a composite of all the IDEA scripts for each stage of the process I want to automate. The problem I'm having is is keeps telling me I haven't defined my database names; I tried to do this using Dim but it still didn't work no matter what I entered so I removed it.
 

Hi!
May I know if there is a way to hide fields?
p.s I have appended a field and if i were to use remove field function it would return an error

Greetings! (edited)  This is my first post after a year being a member.
I am working in a yearly project and because of that I programmed everything in IDEA.  My Project Manager asked me to program everything in a way that anyone, with little IDEA knowledge, can run it.  I have many IDEAScripts that I wrote to perform all the analysis.  Now I added dialogs to make it easier.  Everything runs great without errors. Almost perfect! But (there's always a but)... 

Hi, I am very new to programming and would like to know how i can use data being entered into edit input boxes in my code.

Hello, my current data include the travel's start date and end date. 
 
I hope to identify duplicate entries(employee ID) with all overlapping travel date. May i know how can i go about doing it?
 
 
regards,iceshock

Hi All,
I completed a few group projects via using IDEA macro, while I need to export the history, PDF version, from databases manaually for documentation purposes.
I read Language Browser for help, and it seems no introduction on that is about history export.
How could I get the history from databases automatically rather than manaually exporting them one by one?
Seeking for your advice.
Regards
 

Can IDEA script reference DLL's and tlb's similar to what you do in Excel VBA.  If so, how?
I would like to reference Microsoft ActiveX Data Objects 2.8 Library.
See attached screenshot.