February 27, 200916 yr Can a VBS script return values to FM? ...kind of, but not directly, take a look at this link (and the vbs script is produces)... Link to Post about this....
March 1, 200916 yr No directly, no. You can run a script through so you can prepare a file to be imported and then run a script that will import your file... If FMI updated the FM activeX model to allow passing a parameter to a script then we would be so much closer...
April 12, 200916 yr Keep in mind also, you can get data back into FM through the clipboard, I've used this mostly from DOS but it works from VBS also. You can use either the IE method, or any one of numerous ActiveX's for this purpose. If the VBScript outputs to a file, you can also use CLIP.EXE to get the file into the clipboard.
April 12, 200916 yr True, but using the clipboard is considered bad programming in every environment since it destroys whatever the user may have on their clipboard. You can get around that by going to extra lengths to save and restore the clipboard but the extra code is not worth it usually. Using the import mechanism is a lot more reliable and allows for better error trapping.
Create an account or sign in to comment