1 of 1 people found this helpful
Hi Nathan - that is doable - however, I have not found a way to trig the 'Report->Excel' from automation.
Some years ago I came across an automation script for exporting/importing Variant data. Over the years, that piece of automation has evolved into the one that is attached. I recall adding the pdf stuff, but I donøt think that I can take credit for the excel part (except for adding it as an option instead of it being on be default).
The way the excel writing is implemented will even allow to you change the output (unlike the built-in feature).
The script is form.based, so you need to open it with 'File->Open File' from DxDesigner.
Have fun with it - mark this thread as useful, and of course : get back to me if you need further assistance...
Cheers - and a Happy New Year!!
Thanks Peter, I didnt expect it to be capable from an automation script, but this form will get me where i need to be.
Thanks for your time,
- Nathan Champion
I am trying to use this to import variants into Xpedition. When I open the script in Xpedition and select the Import option I get an error: "Object doesn't support this property or method : dxdApp.GetProjectData". Does this script not work in Xpedition?
No, the script is intended to be used from DxDseigner, sorry ;-)