RE: Foxpro and Excel question

2012-01-25 Thread Richard Kaye
el, I dunno... :) -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, January 25, 2012 3:26 PM To: profoxt...@leafe.com Subject: Re: Foxpro and Excel question I'm confused, however.   You c

Re: Foxpro and Excel question

2012-01-25 Thread Michael Madigan
fe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, January 25, 2012 2:20 PM To: profoxt...@leafe.com Subject: Re: Foxpro and Excel question There's a display limit, but can you print it?    From: Richard Kaye To: "pro

RE: Foxpro and Excel question

2012-01-25 Thread Richard Kaye
xtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, January 25, 2012 2:20 PM To: profoxt...@leafe.com Subject: Re: Foxpro and Excel question There's a display limit, but can you print it?    From: Richard Kaye To: "profox@leafe.com" Se

Re: Foxpro and Excel question

2012-01-25 Thread Michael Madigan
There's a display limit, but can you print it?    From: Richard Kaye To: "profox@leafe.com" Sent: Wednesday, January 25, 2012 2:12 PM Subject: RE: Foxpro and Excel question Hmm... Not exactly. Don't confuse display with capacity. See t

RE: Foxpro and Excel question

2012-01-25 Thread Richard Kaye
ry 25, 2012 1:58 PM To: profoxt...@leafe.com Subject: Re: Foxpro and Excel question I think it may be up to 1024 now, but you're right.  We wound up scrapping this because our memo fields are bigger than that.  i wound up just creating an Excel sheet with a line for each

Re: Foxpro and Excel question

2012-01-25 Thread Michael Madigan
ofoxt...@leafe.com Sent: Wednesday, January 25, 2012 1:05 PM Subject: RE: Foxpro and Excel question Keep in mind that the character limit in Excel is 255. You might end up loosing data. Richard A. Mertl, C.A. T 514 885 4257 F 514 481 6196 E rame...@richardamertl.ca W www.richardamertl.ca Member of L&

RE: Foxpro and Excel question

2012-01-25 Thread Richard A. Mertl
ofoxt...@leafe.com Subject: Re: Foxpro and Excel question Thanks Fred.   From: Fred Taylor To: ProFox Email List Sent: Monday, January 23, 2012 8:15 PM Subject: Re: Foxpro and Excel question You need to set the VerticalAlignment for all cells or even columns

Re: Foxpro and Excel question

2012-01-23 Thread Michael Madigan
Thanks Fred.   From: Fred Taylor To: ProFox Email List Sent: Monday, January 23, 2012 8:15 PM Subject: Re: Foxpro and Excel question You need to set the VerticalAlignment for all cells or even columns to be: #DEFINE xlTop  -4160 .VerticalAlignment = xlTop

Re: Foxpro and Excel question

2012-01-23 Thread Fred Taylor
You need to set the VerticalAlignment for all cells or even columns to be: #DEFINE xlTop -4160 .VerticalAlignment = xlTop Fred On Mon, Jan 23, 2012 at 6:06 PM, Michael Madigan wrote: > I got this code from the internet to extract memo fields from foxpro into > excel > cTabla = GETFILE("dbf"

Foxpro and Excel question

2012-01-23 Thread Michael Madigan
I got this code from the internet to extract memo fields from foxpro into excel cTabla = GETFILE("dbf")  oExcel = Createobject("Excel.Application")  oExcel.WorkBooks.Add sele &cTabla Set Talk Off  nNumRegExp = Reccount() && Total records For i = 1 To nNumRegExp      WAIT WINDOW "Exporting data: