I'm trying to pass a file number from one function to another (so I can open a file in one function and then print to it in another). However I can't seem to find the proper syntax in order to do this.

Any help would be greatly appreciated.

hi there..

can you be more explicit??

the file number is just a long, what's the problem with that???

HTH

Gonzalo

Here's my calling function code:
ControlFilename = GetTempDir & "\\" & GetControlFilename & ".txt"

Open ControlFilename For Output As #2 Len = 200

How do I pass the #2 to the calling function ? If my calling function is PrintData what would the argument that I pass to it ?

Thanks !

yourdestfunction (lFileNumber as long)

never use a static file number, better use a variable and get the number for it using
from msdn


Returns anInteger representing the nextfile number available for use by the Open statement.

Syntax

FreeFile[(rangenumber)]

Remarks

Use FreeFile to supply a file number that is not already in use



HTH

Gonzalo

just a clarify: the file number is an interger, not a long.
A better syntax is:

YourDestFunction(byval lFile as Integer)

Marco

so how do I refer to the passed file number in the called function ?

Usually I use the following syntax: print #2 variable1, variable2

Thanks in advance for the help !

hi again..

print #yourvariable variable1, variable2....

HTH

Gonzalo

Thanks ! That works !