Retrieve data from VBS?

[El_Pablo]

Hi,

I've never use VBS before. Can a VBS script return values to FM?

Thanks

[aholtzapfel]

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....

[Wim Decorte]

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...

[fseipel]

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.

[Wim Decorte]

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.