470,810 Members | 1,444 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

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
Mar 25 '08 #1
2 5914
On Tue, 25 Mar 2008 07:03:28 +0100, "frank knuckles"
<kn*********@support.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
Mar 25 '08 #2
Thanks! That I was looking for.

FK

"Tom van Stiphout" <no*************@cox.netschreef in bericht
news:da********************************@4ax.com...
On Tue, 25 Mar 2008 07:03:28 +0100, "frank knuckles"
<kn*********@support.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

Mar 25 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Mike | last post: by
4 posts views Thread by IMS.Rushikesh | last post: by
14 posts views Thread by pmud | last post: by
2 posts views Thread by Lars Netzel | last post: by
13 posts views Thread by Niyazi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.