![]() ![]() ' Clean up the xml table by deleting all the graphic related entries Worksheets("SDLTMT").ListObjects(Worksheets("SDLTMT").ListObjects.Count).Name = "XMLtable" Set sdltmtWorksheet = Worksheets("SDLTMT")ĪctiveWorkbook.XmlImport URL:=xmlFilePath, ImportMap:=Nothing, Overwrite:=True, Destination:=Range("$A$1") Set sdltmtWorksheet = Worksheets.Add(After:=Worksheets(Worksheets.Count)) If TypeName(xmlFilePath) = "Boolean" Then Exit Sub Title:="Open SDL Threat Modeling Tool File", MultiSelect:=False) XmlFilePath = Application.GetOpenFilename _ ![]() 'Let the user select the correct TM7 file to load Using VBA it would look something like this: Well you can import the TMT XML file into Excel and gain access to all of the data that is used to create the report. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |