View Single Post
  #4   Report Post  
Posted to comp.lang.javascript,microsoft.public.excel.programming
Derek Richards Derek Richards is offline
external usenet poster
 
Posts: 5
Default Can anyone find what is wrong with the following?

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?



"Tim Williams" wrote in message ...
Post the code you have that doesn't work....

Tim



"Derek Richards" wrote in message
om...
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.