that sounds good,I will try it tomorrow at my office, on my Linux PC I have no excel installed, though I have virtualbox installed I have no licence to install excel.
Mareks proposal for checking for the first empty row doesn't work for me, but:
The last row has a cell always containig the same string (it's a footer row) so I could check instead for this string and then exit the loop.
Or I will check backwards for the first not emtpy row. (sophisicated)
I think this method is sure better, maybe one day they change the footerrow
Btw I think for further questions which I am afraid will occur, I will open a new thread with a new topic.
Guys, you are great, thank you so much.
Last edited by ROBROS
on Tue Sep 05, 2017 7:03 pm, edited 3 times in total.