Export to Excel Quickly?

Hello David and welcome to the site.

Try this out and see if it fits your needs.  There is a function Client.CurrentDatabase that gets the current database.  I then extracted the name of the database and had to remove the IMD and replace it with the XLSX extenstion.  When you run it, it should automatically save an Excel spreadsheet in your project folder.

Sub Main
	Call ExportDatabaseXLSX()	'1 Tender=MasterCard.IMD
End Sub


' File - Export Database: XLSX
Function ExportDatabaseXLSX
	Set db = Client.CurrentDatabase
	Set task = db.ExportDatabase
	dbname = Client.CurrentDatabase.Name
	dbname = Mid(dbname, 1, Len(dbname) - 3) & "XLSX" 'remove the imd from the name and add the excel extention
	task.IncludeAllFields
	eqn = ""
	task.PerformTask dbname , "Database", "XLSX", 1, db.Count, eqn
	Set db = Nothing
	Set task = Nothing
End Function

David, if you are using version 9 I would suggest you attach it to a ribbon for easy access.  I am at work now and don't have access to V9 so I will give more detailed instructions when I get home tonight.   Glad it worked.

Hi David, like I said before you should attach this to the ribbon so that you have easy access to it.

I would first copy it to your local libray and then attach it to your ribbon.  Here are the steps if they don't make sense let me know and I can probably post a vidoe of how to do it.

1. Go to your Library (if you are not sure where it is it would be next to the File Explorer tab on the left hand side)
2. Under Current Project Library (where your script is stored) open the macros folder and right click on the script and select "copy to local library"
3. Now it is part of the local library we will attach it the ribbon.
4. Select the Macros ribbon and then select Bind to Ribbon
5. In the Choose command select the New button at the bottom.
6. Under filename browse to C:\Users\User\Documents\My IDEA Documents\Local Library
7. Select the Macros.ILB folder
8. Select your script
9. Select a symbol from the list
10. On the right hand side under "Customize the Ribbon" click on Macros and then click on the New Group button at the bottom.
11. Select the Rename button and give it a name, this will create a group so you might want to call it "IDEAScripts" or something.  Click ok
12. Now select your script from the left hand box and select the Add button.  The script will now be found under the IDEAScripts group so you can use it like any other item.

The reason I moved the script to the Local Library is if you ever delete or move the project the script will still be available.

Let me know if this makes sense.

Iam using IDEA 3 
error on line: 12 - object doesn't support this property or method