Exporting several IMD files

5 posts / 0 new
Last post
Nyax
Offline
Joined: 08/28/2014 - 12:01
Exporting several IMD files

Hi
Someone assist in a script that will export NAMED files to excel without prompting me to select the files.
 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Nyax,

Not a problem to help you.  So when you say NAMED files do you mean all the files in the project folder?  Also are the files going into separate Excel files or into the same one?

Thanks

Brian

wsn4iv
Offline
Joined: 06/21/2016 - 16:02

I am also curious about this. I have a list of databases that I need to export on a regular basis into one Excel file. It would be easier to not have to select them all the time since the names do not change.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi wsn4iv, did you see this posting? http://ideascripting.com/forum/export-multiple-files-idea-excel

It can be modified that instead of asking for the files you can just store your files in an array that the script would reference.

unis
Offline
Joined: 10/19/2015 - 05:09

Hi Brain,How to export multiple data files (imd file) to multiple worksheets in one Excel file?I tried (the script below), but it seems that it can only be written to one sheet (override old sheet) of an excel file.
Function ExportDatabaseXLSX
task.PerformTask "D:\.......\Exports.ILB\UNBILL SO_XX060420.XLSX", "ZM01", "XLSX", 1, db.Count, eqn
Set db = Nothing
 Set task = NothingEnd Function
Function ExportDatabaseXLSX1  task.PerformTask "D:\....\Exports.ILB\UNBILL SO_XX060420.XLSX", "ZM03", "XLSX", 1, db.Count, eqn Set db = Nothing Set task = NothingEnd Function
The 2nd file (UNBILL SO_XX060420, Sheet ZM03) will overwrite the 1st file (UNBILL SO_XX060420, Sheet ZM01).I've tried to include the "Append" function as suggested in your comment on earlier related post, but dont know how.Attached with are the Export Script & 2 IMD files.Really hope, there are ways to enhance the scrpit - to add "Append" command, as your suggestion.
Regards & thanks

Images: