OLE Syntax (2002/XPSP3)

Topic

New Reply

Hi all,

I am using JavaScript to run excel throught OLE.

I ma having a problem with the syntax required fro the command

MsExcel.Workbooks(WorkBookName).Close

What I would like to do is append SaveChanges:=False to the command but I cannot make it work.

In short how can I get the command below to be accepted in JavaScript?

MsExcel.Workbooks(WorkBookName).Close SaveChanges:=False

Thanks in advance for any advice

Reply | Quote

Replies

Try

MsExcel.Workbooks(WorkBookName).Close(False);

Reply | Quote

Hans,

That worked fine. Once I figured out that JScript likes ‘false’ not ‘False’…

The solution is pretty obvious when you are given it.

Thanks for thehelp.

Reply | Quote