I have to output a text in VBA
Path = "c:\temp\result.txt"
lineout = FreeFile
Open Path For Output As #lineout
Print #lineout, result
i don't want to have a fixed path
so tha the text file can just be saved under the same folder as the workbook
i have tried Path = ".\result.txt"
but it doesn't work
what should the path?
thanks a lot!!!