Help Please! Thanks in advance.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Derek Richards
    #1

    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,
    WriteResPasswor d, IgnoreReadOnlyR ecommended, 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.
    Tags: None
    • Tom Ogilvy
      #2
      Re: Help Please! Thanks in advance.

      I suspect the file's readonly attribute is set - you will need to change
      that using file io.

      --
      Regards,
      Tom Ogilvy

      Derek Richards <Derek2122001@y ahoo.com> wrote in message
      news:2d38b9ae.0 310211351.6369a 580@posting.goo gle.com...[color=blue]
      > 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,
      > WriteResPasswor d, IgnoreReadOnlyR ecommended, 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.[/color]


        Comment

        • Derek Richards
          #3
          Re: Help Please! Thanks in advance.

          How to change file IO?

          "Tom Ogilvy" <twogilvy@msn.c om> wrote in message news:<vpbifulhh je02c@corp.supe rnews.com>...[color=blue]
          > I suspect the file's readonly attribute is set - you will need to change
          > that using file io.
          >
          > --
          > Regards,
          > Tom Ogilvy
          >
          > Derek Richards <Derek2122001@y ahoo.com> wrote in message
          > news:2d38b9ae.0 310211351.6369a 580@posting.goo gle.com...[color=green]
          > > 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,
          > > WriteResPasswor d, IgnoreReadOnlyR ecommended, 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.[/color][/color]

            Comment

            • Derek Richards
              #4
              Re: Help Please! Thanks in advance.

              Oops! I meant how to change excel file's readonly attribute using file
              IO. Any details? Thanks.


              "Tom Ogilvy" <twogilvy@msn.c om> wrote in message news:<vpbifulhh je02c@corp.supe rnews.com>...[color=blue]
              > I suspect the file's readonly attribute is set - you will need to change
              > that using file io.
              >
              > --
              > Regards,
              > Tom Ogilvy
              >
              > Derek Richards <Derek2122001@y ahoo.com> wrote in message
              > news:2d38b9ae.0 310211351.6369a 580@posting.goo gle.com...[color=green]
              > > 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,
              > > WriteResPasswor d, IgnoreReadOnlyR ecommended, 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.[/color][/color]

                Comment

                • Tom Ogilvy
                  #5
                  Re: Help Please! Thanks in advance.

                  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" <Derek2122001@y ahoo.com> wrote in message
                  news:2d38b9ae.0 310220848.5a7a1 13d@posting.goo gle.com...[color=blue]
                  > Oops! I meant how to change excel file's readonly attribute using file
                  > IO. Any details? Thanks.
                  >
                  >
                  > "Tom Ogilvy" <twogilvy@msn.c om> wrote in message[/color]
                  news:<vpbifulhh je02c@corp.supe rnews.com>...[color=blue][color=green]
                  > > I suspect the file's readonly attribute is set - you will need to[/color][/color]
                  change[color=blue][color=green]
                  > > that using file io.
                  > >
                  > > --
                  > > Regards,
                  > > Tom Ogilvy
                  > >
                  > > Derek Richards <Derek2122001@y ahoo.com> wrote in message
                  > > news:2d38b9ae.0 310211351.6369a 580@posting.goo gle.com...[color=darkred]
                  > > > 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,
                  > > > WriteResPasswor d, IgnoreReadOnlyR ecommended, 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.[/color][/color][/color]


                    Comment

                    Previous template Next
                    Working...