Can anyone find what is wrong with the following?

  • Thread starter Thread starter Derek Richards
  • Start date Start date
D

Derek Richards

The following syntax is what I found under the Help in Excel's VBA
Editor (you may refer to it for the details of each parameter). i
specified to open in Write
mode (Read Only is false), it doesn't do the way as I wished to open
in
Write mode. Instead, still saw (Read Only) above the MenuBar on the
upper
left corner when an excel file is opened.


Syntax

expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password,
WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter,
Editable, Notify, Converter, AddToMRU)


Here I care nothing else but opening a file in Read & Write. How to
specify the parameters to open in Read & Write in javascript given the
syntax?

Thanks very much.
 
In vba, you would leave arguments blank in a comma separated list

Workbooks.Open(myFile,,false,,,,true)

I don't know what the rules are for Javascript.
 
Hi Tim, thanks.

Here it is.

e.Workbooks.Open(strFileName, null, false, null, null, null, true);

However, the file is still opened in Read-Only. How strange it is! Any suggestions?
 
Back
Top