I'd like to write a text file from each of my conditions from my looping statement.
Then each text file will be written to my workbook sheets.

On my workbook,

Let's say Condition1
Will write a text file named text1.txt
Then text1.text will be written to Sheet1

Then Condition2
Will write a text file named text2.txt
Then text1.text will be written to Sheet2


I am initially using,

to write to the text file,
Open text1.txt For Output As #1
Print #1
Close #1

to read from the text file,
Open text1.txt For Input As #1
Print to my cells
Close #1

What is the significance of #1? What happens when this number is changed as I write/read the text files?

May I ask for your expert advice on doing this?