Hey Alex

You where right!!

after looking at the macro tool for excel I ran a test about 50% of the code worked fine the other 50% just took a little gray matter. The "xTopBorder" had to be replaced with numbers, after a few test I found the number(s) I was looking for.

Like someone in this thread said, it is kinda slow but works like a charm

Thanks for the insight, you helped me a lot!!!




>>Wow you went out of my leauge, macros and VBA, I just want the data exported the column widths and colors are not a big issue with me. I do thank you for the options.
>
>It is very easy to do. Never fear.
>
>
>>how do start the macro recorder?
>ALT-F8 or Tools|Macros
>
>
>>don't a lot of people think macros are bad (in general) cause of macro viruses??
>
>Macros are a misnomer. A remnant from the past. They are actually VBA programs.
>Yes, they can carry a virus, like most programming languages. But here I am not saying that you create and use a VBA program (macro). Just to use the recorder to grab your keystrokes so you can learn how to write Excel automation code in VFP.
>
>
>>what does VBA stand for? Visual Basics A?????
>
>Visual Basic for Applications. A subset of VB, it is the language behing MS-Office (Word, Excel, Outlook, Powerpoint, etc). Provided you use Office 97 or greater.
>
>HTH