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

Parents

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

Reply

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

Children

No Data