IDEAScript Questions
Overlapping of Dates
Forums
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
- Read more about Overlapping of Dates
- 1 comment
- Log in or register to post comments
How to export history from databases using IDEA script?
Forums
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
Excel VBA Referencing
Forums
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.
- Read more about Excel VBA Referencing
- 1 comment
- Log in or register to post comments
Create a Preview of Extraction using indexed Actionfield
Forums
Hi,
i need a snippet to create a preview of an extraction. IdeaScript only records the complete macro an creates a new file.
I hope somebody can help me...
Gerold Mammen
Dialog Box to Map Fields
Forums
I'm very new to scripting, and I'm struggling a bit with understanding how to properly use dialog boxes. What I'd like to do is pop up a dialog box to have the user map the fields in their client's data to a standard naming convention, so that I can run a pre-designed analysis. I've been successful at building the script to handle the analysis part by using the macro recorder and the history, but I'm stumped on the dialog box part.
- Read more about Dialog Box to Map Fields
- 11 comments
- Log in or register to post comments
Number Identification/Extraction In Text String
Forums
Hi Brian!
I hope all is well with you!
I was wondering if you could help me.....
Adding fields from another database without creating a new table
Forums
Hi Brian,
While doing a Join to get a field from another database, a new database gets created. So there are multiple steps invovled in scripting due to this since i have to then delete the original database and then rename etc.
Is there a way to add a field to the existing database itself without creating a new database? Can i do this through script or custom function?
Regards
Padma
Userform with dropdown listboxes
Forums
Hi Brian,
Can you maybe help me with this script? In order to prevent a script crashing because of varying field names, I would like to create a script that runs based on pre-identified field names that the user selects with dropdown listboxes. I managed to steal some from the scripts you placed on this site, but I'm stuck after the first listbox.
- Read more about Userform with dropdown listboxes
- 13 comments
- Log in or register to post comments
using database name as data in newly appended column
Forums
hi bryan,
Error Handling and Empty Tables
Forums
I have scripts that compare an active employee list with an access list from various systems. For example AD. At the end of the day, I end up with two tables. One that shows people who have access to the system that are active employees and another one that shows accounts that don't belong to active employees. The two tables then get exported to Excel. The goal is to have nothing in the inactive employee listing.
- Read more about Error Handling and Empty Tables
- 6 comments
- Log in or register to post comments