Kenneth Hobs, actually, the output example that I've provided in the first post above is exactly what I want.
The filename for this particular output will be 166143000003.txt (the unique property id of "Paz" which its data is collected)
I've also attached a "Sample.xls" in the first post here. That's the file from the screenshot.-------------------------------------------------------
OUTPUT EXAMPLE:
Business Name: Paz | Owner ID: 510216054 | Property ID: 166143000003 | Owner Name: Paz Company Ltd. | Owner Address: P.O.B. 222 City
(Sign Content | Width (cm) | Height (cm) | Rounded Area | Sign Address - Street | Sign Address - House | Sign Location)
Tasty Yellow | 250 | 230 | 6 | rd. 434 | 21 | Display Window
Paz (changing ads) | 90 | 60 | 1 | rd. 434 | 21 | Bulding Wall
Paz (changing ads) | 90 | 60 | 1 | rd. 434 | 21 | Bulding Wall
Price List | 120 | 60 | 1 | rd. 434 | 21 | Pole
Paz | 80 | 60 | 1 | rd. 434 | 23 | Gas Station
-------------------------------------------------------
The method should create a separate txt file for every property id, printing the owner and business info (which are the same in all of the property lines) at the top of file, then a simple text line of titles related to signs, and under that the collected-by-loop sign data.
Now, about the text styles, you can ignore them. Currently, I need plain text.
In fact, I want to create html files finally, but as soon as I understand how the printing and looping work, I'll just edit the plain text and put html tags in it.
Finally, about the code\method I suggested:
If you wish, you can treat it as a textual algorithm which I want to implement in vba, and need your help with that. I've worked on it quite a while, in order to help the rest to help me.
I think that *it is* close enough to what I need, and *does* work somewhat, from the little clue I (and Google) have about vba, as I said.
Thanks![]()