Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel times out
Message
De
07/01/2005 10:58:46
 
 
À
07/01/2005 10:52:12
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00975101
Message ID:
00975114
Vues:
13
Yes, but I don't understand why that should not fix your problem. If you don't send any commands to Excel for a period, Excel should work on it's own anyway doing nothing, and then there should be no need for any more delay, as far as I can see. Have you tried to run one command at a time from the command window?

>It's Excel that's busy somehow so the messagebox comes up with the select, retry option
>
>wait window just postpones the problem by 1 second
>Peter
>
>
>>Hi Peter,
>>
>>You can add any VFP code anywhere, just add a WAIT TIMEOUT 1 WINDOW or something like that before your problem line.
>>
>>>the following code stops:
>>>
>>>oExcel=CREATEOBJECT("excel.application")
>>>oExcel.DisplayAlerts=.F.
>>>oWorkBook=oExcel.workbooks.ADD()
>>>oSheet=oWorkBook.Worksheets(1)
>>>WITH oSheet.PageSetup
>>>.Orientation=1      <----------------------------HERE !!!!!!!!
>>>.FitToPagesTall=1
>>>.FitToPagesWide=1
>>>.CenterHorizontally=.T.
>>>.CenterVertically=.F.
>>>.TopMargin=1*72
>>>.LeftMargin=.75*72
>>>.RightMargin=.5*72
>>>.RightHeader="Page &P of &N"
>>>.LeftHeader="&F"
>>>.RightFooter="Printed on &D"
>>>.FooterMargin=.5*72
>>>.HeaderMargin=.5*72
>>>
>>>
>>>ENDWITH
>>>
>>>I assume it times out somehow( running on Terminal Server 2000 )
>>>Can I change the timout when talking to EXCEL?
>>>
>>>Peter
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform