Hi All
I have a vba procedure that writes out a content of an array to a txt file. I use write function within a for each loop to achieve this.
The problem is that after the last line is written to a file a new line is fed. How could I prevent from cursor being moved to a new line after the last record is written out?
I understand 'write' function move the cursor to a new line. I could use some other function (print?) for the last line to be written out outside the loop. However, 'write' puts the data elements between inverted comas which is my requirement.
Is there a way to achieve what I need?
Appreciate any suggestions.
Thanks
Marek
I have a vba procedure that writes out a content of an array to a txt file. I use write function within a for each loop to achieve this.
The problem is that after the last line is written to a file a new line is fed. How could I prevent from cursor being moved to a new line after the last record is written out?
I understand 'write' function move the cursor to a new line. I could use some other function (print?) for the last line to be written out outside the loop. However, 'write' puts the data elements between inverted comas which is my requirement.
Is there a way to achieve what I need?
Appreciate any suggestions.
Thanks
Marek