Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to Insert Excel Page Breaks
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00434717
Message ID:
00434775
Views:
16
Agreed. The only times I would make it visible immediately would be when debugging and testing in the command window.

>Yes, that would help, if an unknowing person tried it. Plus, unless the routine is short, I normally don't put in the Visible=.T. statement until after the routine is finished (unless I'm testing it). Otherwise, with intense automation, the process can really s-l-o-w down, due to screen refreshes (even in the background).
>---Michael
>
>>Your welcome Michael. Just for the record, the example was missing one line:
>>
>>oXL=createobject('excel.application')
>>oXL.visible = .t.
>>oXL.Workbooks.Add
>>oXL.Range("A6").Select
>>oXL.ActiveWindow.SelectedSheets.HPageBreaks.Add(oXL.ActiveCell)
kenweber
GCom2 Solutions
Microsoft Certified Professional

Previous
Reply
Map
View

Click here to load this message in the networking platform