At first, i was in need to export from access a formatted excel report and i reached my goal. The thread is here. https://www.access-programmers.co.uk/forums/showthread.php?t=308329 In this address i found the code which i fixed to my needs...
The above thread, in which i mastered the way of exporting formatted excel from access, has help a lot, i complete fast complicated reports.
Now i have a new report that i made last week, i cannot find the way of sorting the report based on a "field" which its data is displayed into colon B.
I do it manually but if there was a line of code that i could add in the vba, that would be great.