left function in vba powerpoint -

-

i trying take part of string in powerpoint using vba. trying use following code lines: 

                    dim strie string                     strie = sh.name                     sbody = left(strie, 5)

i don't know why giving me "run-time error '13': type mismatch" error. try using following line instead of last one:

                    sbody = left(strie, 5)

but 1 gives me "compile error: type-declaration character not match declared data type" error before starting exec code.

how can use left , right functions? in excel work here cannot make them work.


Comments

Post a Comment

Popular posts from this blog

c - sscanf() double showing zeros -

-
i'm having troubles sscanf() function read doubles. have comma separated text file this: abc,def,0.465798,0.754314 ghi,jkl,0.784613,0.135264 mno,opq,0.489614,0.745812 etc. so first line fgets() , use sscanf() 2 string , 2 double variables. fgets(buffer, 28, file); sscanf(buffer, "%4[^,],%4[^,],%lf[^,],%lf[^\n]", string1, string2, &double1, &double2); printf("%s %s %f %f\n", string1, string2, double1, double2); but output is: abc def 0.465798 0.000000 ghi jkl 0.784613 0.000000 mno opq 0.489614 0.000000 so somehow doesn't scan last float. i've tried %lf[^ \t\n\r\v\f,] , %lf still doesn't work. change "%4[^,],%4[^,],%lf[^,],%lf[^\n]" to int result; result = sscanf(buffer, "%4[^,],%4[^,],%lf,%lf", string1, string2, &double1, &double2); if (result != 4) // handle error notice & on double1 , double2 - likley typo. also strongly recommend check result 4. not checking sscanf(...
Read more

pentaho - Carte Status / Kettle Slave Server Status page shows status for random runs instead of the latest run -

-
i trying programmatically details of specific execution of transformation what have tried far i status of kettle slave server/carte @ http://localhost:8282/kettle/status/ from page, can click on desired transformation , taken page shows details , has link xml output current status of specific execution of transformation. link this: http://localhost:8282/kettle/transstatus/?name=trans_name&id=carte_ob_id&xml=y the problem i have transformation has been run multiple times recently. don't have carte_obj_id specific run of transformation. so, can't provide in uri. if try following uri instead: http://localhost:8282/kettle/transstatus/?name=trans_name&xml=y then status of random execution. not latest 1 or specific one. the goal i writing .net gui have code. httpwebrequest req = (httpwebrequest)webrequest. create(@"http://localhost:8282/kettle/transstatus/? name=trans_name ...
Read more