Exporting several IMD files
Forums
Hi
Someone assist in a script that will export NAMED files to excel without prompting me to select the files.
Hi wsn4iv, did you see this
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.
Hi Brain,How to export
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
Hi Nyax,
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