Setting a File Attribute to Hidden

[Mota]

Hello;
I want to change attribute of a table-based text file saved outside my
program (to prevent it from accidental handling by the user) and set it to
hidden through code.How to do it?
Thank you so much in advance.

 

[Nikos Yannacopoulos]

Try this:

Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile("c:\MyFile.txt")
f.Attributes = 2

(modify path and file name accordingly).

Nikos

 

[Dirk Goldgar]

Try this:

Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile("c:\MyFile.txt")
f.Attributes = 2

(modify path and file name accordingly).

Nikos

Don't you think that's overkill, for a function that is built right into
VBA? Why not just

SetAttr "c:\MyFile.txt", vbHidden

?

 

[Nikos Yannacopoulos]

Dirk,

Thanks for the tip!

Nikos

-----Original Message-----


Don't you think that's overkill, for a function that is built right into
VBA? Why not just

SetAttr "c:\MyFile.txt", vbHidden

?
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

 

[Mota]

Thank you;

Don't you think that's overkill, for a function that is built right into
VBA? Why not just

SetAttr "c:\MyFile.txt", vbHidden

?
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)