Make Excel-file Read Only

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

    Make Excel-file Read Only

    After exporting an Access table to Excel, I would like to make the Excel
    file Read-Only. Is it possible to do this with VBA from within Access?
    Thanks.

    FK


    Tags: None
    • Tom van Stiphout
      #2
      Re: Make Excel-file Read Only

      On Tue, 25 Mar 2008 07:03:28 +0100, "frank knuckles"
      <knucklehead@su pport.comwrote:

      Check out the SetAttr statement in the help file.
      -Tom.

      >After exporting an Access table to Excel, I would like to make the Excel
      >file Read-Only. Is it possible to do this with VBA from within Access?
      >Thanks.
      >
      >FK
      >

        Comment

        • frank knuckles
          #3
          Re: Make Excel-file Read Only

          Thanks! That I was looking for.

          FK

          "Tom van Stiphout" <no.spam.tom774 4@cox.netschree f in bericht
          news:da3iu3h29n m7fagm4q2l40h7c obq9mr2d6@4ax.c om...
          On Tue, 25 Mar 2008 07:03:28 +0100, "frank knuckles"
          <knucklehead@su pport.comwrote:
          >
          Check out the SetAttr statement in the help file.
          -Tom.
          >
          >
          >>After exporting an Access table to Excel, I would like to make the Excel
          >>file Read-Only. Is it possible to do this with VBA from within Access?
          >>Thanks.
          >>
          >>FK
          >>

            Comment

            Previous template Next
            Working...