>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.You do not need to guess the magic numbers. Use an include file. You can find Excel.H in many places, including Excel's VBA object browser or also at the Wiki:
http://fox.wikis.com/wc.dll?Wiki~ExcelConstants~VFPPut that in a file called Excel.h and somewhere in your program add:
#INCLUDE Excel.h
Then you can just use the constant's names like
xTopBorder
in your statements.