My engineers have about 20 different (slight exageration) BOM outputs they want to see from DxDesigner. Using the corporate WDIR I can control only one default ipl file so my solution is to create custom scripts available in my own drop down menu in DxDesigner that are preconfigured for specific outputs using icdbPartsLister.exe and the appropriate flags.
The issue I am having is when I try to specify the output file's name when the ipl file is configured to output an excel file. I cannot get this to work for the life of me but I am having no problems when the output is a plain text file. Has anyone else experienced this? Is this a known bug or am I doing something silly?
Thanks for your time.
dim WshShell, vdapp, vdpd, prjPath, prjFilePath, SDDHOME, WDIRPath, boardName, command
set vdapp = GetObject(,"ViewDraw.Application")
set vdpd = vdapp.GetProjectData
prjPath = vdpd.GetProjectPath
prjFilePath = vdpd.GetProjectFilePath
WDIRPath = \\Some\network\location\wdir
boardName = VdApp.ActiveView.GetTopLevelDesignName
set WshShell = CreateObject("WScript.Shell")
SDDHOME = WshShell.ExpandEnvironmentStrings("%SDD_HOME%")
command = SDDHOME & "\wv\win32\bin\icdbPartsLister.exe -prj=" & chr(34) & prjFilePath & chr(34) & " -board=" & boardName & " -cfg=" & chr(34) & WDIRPath & "\PartsLister\someiplfile.ipl -out=" & chr(34) & prjPath & "\configuredBOM.xlsx" & chr(34)
WshShell.Run command, , TRUE