Pcd2excel script

I want my data to export into an excel format so I tried insert basic script using pcd2excel.bas at the end of my program. When I execute the part program I get a ''Syntax error on line: 14- cmd As PCDLRN_.command"
When I use the Insert External Command and insert the pcd2excel.exe it works. My ultimate goal is to not have to go through the Configure, Cancel, Continue and the Finish prompts that the wizard asks you when it executes the export.
Thanks

AndersI over 10 years ago
If you add the command line parameter A to the External Command, PCD2Excel will not ask any questions (except the first time for each program where you use it). Sorry for Swedish, but I think you'll understand...

EXTERNT_KOMMANDO/INGEN_VISNING, VÄNTA ; C:\PROGRAM FILES (X86)\WAI\PC-DMIS 2013 (RELEASE) 32-BIT\WIZARDS\PCD2EXCEL.EXE A
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Gregsmonti over 10 years ago

Thanks!! Working like a charm. I did have to run the part program twice to get the records to ADD and not overwrite.
Leave the A off and go through the configure screen a second time, then add the A. a new worksheet is created each time after that instead of overwriting. Awesome.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel