Pcdmistoexcell Basic script

[Darin Steiner]

Anyone use this, and if so how did you get this command into your program (see below)?

CS1 =SCRIPT/FILENAME= C:\EXCELSCRIPT.BAS
FUNCTION/LoadExcel,,
STARTSCRIPT/
ENDSCRIPT/

I tried inserting EXCELSCRIPT.BAS from the insert menu, but I'm unable to edit it to match the command above (see below), and how do you insert the ENDSCRIPT/ command?

CS1 =SCRIPT/FILENAME= C:\EXCELSCRIPT.BAS
FUNCTION/Main,SHOW=YES,,
STARTSCRIPT/

Using 3.7mr3

[T Miller]

The first time you run the program the endscript will show up you have to edit to say loadexcel

[why me]

I use this daily like stated before inert basic script then on the function line edit to read Loadexcel where it reads Main
like this
CS1 =SCRIPT/FILENAME= C:\EXCELSCRIPT.BAS
FUNCTION/LoadExcel,SHOW=YES,,
STARTSCRIPT/
ENDSCRIPT/

or just copy and paste this into your programs
this is copied straight from one of mine that I know works

[DaddyBluto]

I found it a lot easier to edit the script so that the subprocedure is called "Main" instead of changing the command to "LoadExcel" in PC-DMIS every time.