Creating Invisible Hiddenn file in Access

[Centaur]

The code for creating a file is

Open "C:\filename.txt" For Output As #1

How can I create this file as invisible/hidden

Thank you

Centaur

 

[TC]

Create it, then use the VBA SetAttr statement.

HTH,
TC

 

[Albert D. Kallal]

Check out

SetAttr in the help:

Cut and paste from the help gives:


Sets attribute information for a file.

Syntax

SetAttr pathname, attributes

The SetAttr statement syntax has these named arguments:


Constant Value Description

vbNormal 0 Normal (default)
vbReadOnly 1 Read-only
vbHidden 2 Hidden
vbSystem 4 System file
vbArchive 32 File has changed since last backup

Remarks

A run-time error occurs if you try to set the attributes of an open file.

 

[Elsie]

Thank you TC and Albert for your replies you have been very helpful

Centaur