IDEASnippets

This function will specifically look to see if an IDEA file exists, it uses the IDEA project management object.  Return True if file exists.

Validate if a file exists, send the file and path information and the function will return True if it exists else it returns False.

This piece of code will extract the filename from a character string that contains the filename and path.

This example script shows how to obtain an excel worksheet name.  This can be handy if importing an excel worksheet and you don't know the worksheets name.

Short function that checks if a file exists, good for checking that a file or rdf file exists.  
Returns true if the files exists else it returns false.
The function expects the name of the file along with the path information.

Code to time your script.

I use the Type procedure that allows you to create a user-defined data type containing one or more elements.  I create an element for each of piece of information that is contained in the field then I use this type as an array and populate it with all the field information.  This is an easy way to get all the information on the fields in a database in a quick manner.

This is a demo program on how you can populate a list box based on a selected field.

This demo script will show you how to populate a drop-down based on the contents of the previous drop-down.  In this example it will take the contents of the field t

This snippet of code will delete al the IDEA files in an IDEA project folder.