Skip to content

Instantly share code, notes, and snippets.

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

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.