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