View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Foss Foss is offline
external usenet poster
 
Posts: 22
Default Logging things..

Mornin' all!

I'm using something like this to log progress and errors
etc to a text file:

LogFile = CleanFolderPath("MY FOLDER PATH HERE") & MyDoc
& " Run Log.txt"
Open LogFile For Output As #1
Print #1, "Report page " & MyRepName & " saved to " &
MySaveLocation

etc etc.

There is the potential for two files to be open at once,
how can I use the first available number instead of the #1?

Cheers,
Foss