Creating macros for the excel sheet in VBscript or Javascript

Question

I have been using VBscript for writing macros in the excel. But can I write javascript as well for writing the macros?

If yes , then which is much better and why?

Ansgar Wiechers · Accepted Answer · 2016-03-14 15:49:47Z

2

Excel macros can't be written in either VBScript or JavaScript. The language used in Microsoft Office macros is VBA (Visual Basic for Applications), which is similar to VBScript, but not identical.

What you can do with both VBScript and JavaScript is COM automation of Office applications (running from .vbs or .js files respectively):

var xl = new ActiveXObject("Excel.Application");
xl.Visible = true;

var wb = xl.Workbooks.Open("C:\\path\\to\\your.xlsx");
var ws = wb.Sheets(1);

ws.Cells(1,1).Value = "something";

wb.Save();
wb.Close();
xl.Quit();

However, you'll still be using VBA objects and methods that way.

answered Mar 14, 2016 at 15:49

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating macros for the excel sheet in VBscript or Javascript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related