Excel automation in FoxPro 7

[igorsandler]

Hello,
I have a situation when I need to format Excel file column(file created programmatically with Excel object) that contains Social Security numbers to be right justified. The problem I have is with SSN with leading zero(s). They are coming out left justified.

Ideally I would like to programmatically format Column as General or Text and set it to have right alignment. I tried to use:

oSheet.RANGE["D","D"].EntireColumn.NumberFormat = "General"
oSheet.COLUMNS("D").EntireColumn.AutoFit

Getting an error on the first line, due to incorrect reference or syntax.

Any help would be appreciated.

Also, is there a decent manual or book or whatever on how to use Excel automation with FoxPro 7?

Igor

 

[TamarGranor]

Try recording a macro in Excel doing what you want to do, and look at the code to see one right syntax. Off the top of my head, you probably need to eliminate "EntireColumn." from that code.

The book Della Martin and I wrote on automating Office should work for you, though of course, all the Office apps have lots more functionality since then:

http://www.hentzenwerke.com/catalog/autofox.htm.

It's not available in print anymore, but you can buy and download the ebook.

I've also written some articles that might help you get started, but they're not in depth. You'll find my papers at

http://tomorrowssolutionsllc.com/conferencepapers.php;

use the Categories filter to select "Microsoft Office." (Full disclosure: Della wrote the Excel chapters, so my papers tend to focus more on Word.")

Tamar