Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel times out
Message
From
07/01/2005 10:52:12
 
 
To
07/01/2005 10:42:38
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:
00975106
Views:
20
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
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform