Questons on exporting

Good morning!
As in the message that can be seen below I would like to know more about connecting BI to my created works in IDEA.
Obs: currently all the files I extract from IDEA give error when trying to load in BI.Some files get an error that is impossible to load, others don't, the inconsistency is frustrating.

Hello,
 
I have some code that exports a database to an Excel file and I was wondering how I could go about formatting the excel file.  I am looking to make the top row bold and filterable and then auto fitting the columns.  I have tried looking for examples but I guess I'm looking in the wrong places.
 
Heres what I have for my export.  Thanks!
 
ExportDBsmzCYPYxlsx
Set db = Client.OpenDatabase(CYPYsmzn)
Set task = db.ExportDatabase
    task.IncludeAllFields

I have a large DB that needs to be exported to several excel files using equations. E.g extract all records where Comp_code == ABC to file XX_ABC, extract all records where Comp_code == XYZ to file XX_XYZ. I am a newbie in IDEAScripting trying to automate this so that I don't have to repeat the same steps manually.

Hi, 
I am trying to run a macro in which I export an .IMD to an excel. Th epoint is that I am overwritting the same excel. I mean, I export the same excel for several times, with the same name. But sometimes I get the following error:
The .excel is beeing used or is just a reading file or  another thing I can`t remember now.
Do you know why sometimes the code throw me this error but not always? like it depends on the luck I have that I get the error or I don`t.
 

Hi can anyone help to guide me to modify the below export script so that i can export my excel with the datestamp everytime i run it? Thank you!
i.e.
if I run it today, the output file will be 18. Duplicate Payment Month 280420.xlsx
if i run it tomorrow it will be 18. Duplicate Payment Month 290420.xlsx
Script:

The history function, while it provides a great, detailed audit trail, it is very difficult for others to learn how to read as well as review.  Has anyone else had this issue and figure out a way to get a simple revieable document?

Hi Brian, 
do you know if it is possible to export data from IDEA to the json format?
I would like to export the data within our script and import it to PowerBI.
I havent found anything in the menus or the internet - so I've planned it to export to a delimited utf8 file as workaround.
 
Thx in Advance :)
Greets
Norbert

I am looking to export to an Excel file or template that already contains column headings and formatting in row 1.  So, I just want the database data from IDEA, not the header.  I can't change the column names in the IDEA database due to special character and  number of character limitations.  Any suggestions?
 

 
Hi Brian,
Hi members of Idea scripting.com
 
I am a big fan of your work and thanks for this homepage; great inspiration and help.
 

Hi friends.
I need a sample IDEAScript that export a database to an Excel file and insert a VBA macro in that file.
Thank you very much in advance.
Regards from Nicaragua.