Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can somebody please give a hand?
Message
De
06/03/2009 14:35:29
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01386076
Message ID:
01386300
Vues:
94
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>I think I had a program working yesterday correctly. Today I was working on other things and only now I've been trying to use the program. I've tried for 2 hours already and it's not working.
>
>I can not even make the Excel visible to see what's going on. I added loExcel.visible = .t., but it shows somethat empty Excel without anything.
>
>In my cursor I have 207 records. However, in my Excel output I only have 34 first records. Could it be that UsedRange doesn't work properly or something else is wrong?
>
>I need a second set of eyes to help me debug it.
>
>Could anyone please help?
>
>Thanks in advance.

Naomi,
Thsi runs with no error and completes in less than 2 seconds with no error (1380 records - 1380 rows in excel).
Rand(-1)
Select c.Company,;
	c.Contact, ;
	RTRIM(e.First_Name)+' '+Rtrim(e.Last_Name) As eName, ;
	CAST(Chrtran(e.Notes,Chr(13),'') As m) As Notes ;
	FROM (_samples+'data\customer') c, (_samples+'data\employee') e ;
	INTO CURSOR xx ;
	nofilter

loExcel = Createobject('Excel.Application')
With loExcel
	.Workbooks.Add()
	.Visible =.T.
	VFP2Excel('xx',.ActiveWorkbook.ActiveSheet.Range('A1'))
Endwith
All I did was to remove the codes added by you in VFP2Excel. I didn't try before removing those lines.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform