Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel times out
Message
De
07/01/2005 10:42:38
 
 
À
07/01/2005 10:39:07
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:
00975102
Vues:
18
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform