Excel

3 posts / 0 new
Last post
Robert van den ...
Offline
Joined: 08/08/2018 - 07:37
Excel

Is it possible to export multiply IMD files to one Excel files in different worksheet tabs?
And is there a good guide on how to use VBA Excel? I want to add more worksheets tabs and add text to the diffrent worksheet tabs. I got this far with Google:
 
 
Sub Main
Dim ExcelSheet As Object
Set ExcelSheet = CreateObject("Excel.Sheet")
ExcelSheet.Application.Visible = False
ExcelSheet.Application.Cells(1, 1).Value = "This is column A, row 1"
ExcelSheet.SaveAs "H:\!OHW\IDEA\Test Project 01 (9999990)\Exports.ILB\TEST.xlsx"
ExcelSheet.Application.Quit
Set ExcelSheet = Nothing
End Sub 

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

Hi Robert, do you have access to the CaseWare IDEA Passport site?  There is a script there that does this.

Also here is a discussion on this site about it: http://ideascripting.com/forum/export-multiple-files-idea-excel

Unfortunately there is no good guide, I found all my info my using google.  There are some discussions on this site about using Excel if you do a search on Excel.  Here is one of the discussions with some sample code to get you started.

http://ideascripting.com/forum/excel-object-models

Robert van den ...
Offline
Joined: 08/08/2018 - 07:37

thanks for your reaction, i got a little further with google and mostly a youtube channel where little pieces of specific code are showed and explained.
https://www.youtube.com/channel/UCVLbzhxVTiTLiVKeGV7WEBg/playlists
https://www.youtube.com/watch?v=FGQ0P9jTjU0&list=PLWPirh4EWFpEFSYTbKaST6hSlgIFCJjU3
 
At the moment everytime i add a analysis to my script i need to manually add table of contents (excel file). I want that excel file being build from the script, so that every time i add a new analysis i can't forget it to add it to the table of contents. I hope you understand it because my Englisch isn't very good ;)