Saturday, 13 May 2017

Using MS Access VBA, can I run Node.js on a JavaScript file through the command prompt and scrape the output?

So:

I'm taking a crash course meant to prepare me for tech interviews with coding boot camps like App Academy. The course is taught in Node.js, and we run our exercises through the command prompt like this: "C:\Users\Mike\Exercises>node problemSet.js".

Now, I have a little MS Access app I cooked up a while back to function something like a set of smart flashcards. I'd like to expand on it so that it can show me a coding exercise, run whatever solution I type out in the Access Form through Node.js, and check that it generates the correct output.

I was hoping to accomplish this with the VBA Shell function, but it seems to only work with .exe files. If I try running it on something like the path in the first paragraph, I get "File not found" because there's no file called "node problemSet.js", just "problemSet.js" that I'm used to running by entering "node problemSet.js" into the command prompt.

Any suggestions?



via ProdigalBulldog

No comments:

Post a Comment