Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
JScriptにて、VBArrayを生成する関数。 JScriptからExcelを操作する際に使用するとよいかも。
function JSArray2VBArray(arr) {
var vbs = new ActiveXObject("ScriptControl");
vbs.Language = "VBScript";
"Function makeArray\n"
+ "makeArray = Array(" + arr + ")\n"
+ "End Function\n");
var ret = vbs.Run("makeArray");
return ret;

This comment has been minimized.

Copy link
Owner Author

commented Mar 26, 2013


Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.