Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel times out
Message
From
07/01/2005 10:42:38
 
 
To
07/01/2005 10:39:07
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00975101
Message ID:
00975102
Views:
19
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform