471,594 Members | 2,644 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,594 software developers and data experts.

Help Please! Thanks in advance.

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.
Jul 20 '05 #1
4 3294
I suspect the file's readonly attribute is set - you will need to change
that using file io.

--
Regards,
Tom Ogilvy

Derek Richards <De**********@yahoo.com> wrote in message
news:2d**************************@posting.google.c 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.

Jul 20 '05 #2
How to change file IO?

"Tom Ogilvy" <tw******@msn.com> wrote in message news:<vp************@corp.supernews.com>...
I suspect the file's readonly attribute is set - you will need to change
that using file io.

--
Regards,
Tom Ogilvy

Derek Richards <De**********@yahoo.com> wrote in message
news:2d**************************@posting.google.c 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.

Jul 20 '05 #3
Oops! I meant how to change excel file's readonly attribute using file
IO. Any details? Thanks.
"Tom Ogilvy" <tw******@msn.com> wrote in message news:<vp************@corp.supernews.com>...
I suspect the file's readonly attribute is set - you will need to change
that using file io.

--
Regards,
Tom Ogilvy

Derek Richards <De**********@yahoo.com> wrote in message
news:2d**************************@posting.google.c 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.

Jul 20 '05 #4
I am talking about changing the file attribute readonly. In VBA this would
be done using setattr

SetAttr "TESTFILE", vbNormal

Your open command gives the option of ignoring readonly recommended which
is Excel's method of making a file readonly.

--
Regards,
Tom Ogilvy

"Derek Richards" <De**********@yahoo.com> wrote in message
news:2d**************************@posting.google.c om...
Oops! I meant how to change excel file's readonly attribute using file
IO. Any details? Thanks.
"Tom Ogilvy" <tw******@msn.com> wrote in message

news:<vp************@corp.supernews.com>...
I suspect the file's readonly attribute is set - you will need to change that using file io.

--
Regards,
Tom Ogilvy

Derek Richards <De**********@yahoo.com> wrote in message
news:2d**************************@posting.google.c 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.

Jul 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by the_proud_family | last post: by
2 posts views Thread by m3ckon | last post: by
12 posts views Thread by Christo | last post: by
7 posts views Thread by Alan Bashy | last post: by
38 posts views Thread by Red Dragon | last post: by
8 posts views Thread by skumar434 | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.