PTV Visum - Frequently Asked Questions (FAQs)

(#VIS12330)

How to export a list from Visum to Excel via Excel/VBA?

With the following example code, a list can be generated and integrated in Excel:
Set aPrtPathList = Visum.Lists.CreatePrTPathLinkList
aPrtPathList.SaveToClipboard UseSeparatorTab

Set wb = ActiveWorkbook
Set ws = wb.Worksheets('aList')
ws.Cells.Delete
ws.Paste


http://vision-traffic.ptvgroup.com/faq-files/PTV_ExportList2Excel.zip