Exporting several IMD files

Nyax

Forums

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

Brian Element Tue, 07/07/2015 - 09:44

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 Thu, 03/23/2017 - 08:06

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.

unis Sat, 04/11/2020 - 01:13

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