VFP VBA to Excel

[kitnba]

&nbsp;&nbsp;&nbsp;xThisSheet.VPageBreaks(1).DragOff direction=xltoright , RegionIndex:=1<br><br>how do I change this VBA to Foxpro format?<br>i want to set move the pagebreak line to the right column.<br><br>thanks

 

[foxdev]

You don't need to change it to VFP.&nbsp;&nbsp;You would be instantiating an Excel object, so the properties you set and methods you invoke of that object will be specific to Excel.<br><br>If you have Office 2000, search for the file <font color=blue>VBAWRD9.CHM</font> (there may be a slightly different file name for earlier versions of Office); it will contain the documentation on the Office object model, including the names and parameters for the methods.<br><br>If you need further details, please let me know. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[kitnba]

I want to know detail. but this statment can't accept at VFP .....<br><br>

 

[stewpot]

Kitnba,<br><br>My understanding is that VBA can reference variables by name, but VFP can't so you have to list the variables. Try this:-<br><br>xThisSheet.vPageBreaks(1).DragOff(-4161,1)<br><br>Alternatively, you can define variables using VFP's preprocessor command #DEFINE.<br><br>You can get the values of Excel object variables by pressing Alt-F11 in Excel, which brings up VBA and then press F2 which brings up the Object Browser (or it does prior to Office 2000).<br><br>If you are doing a lot of automation of Office with VFP, then I can recommend a new book