Excel marco for VFP

[kitnba]

ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1

I am using VFP to create the Excel chart, the above command is come from Excel Marco, how can I convert it to VFP command?

Thanks

 

[monikai]

Hi !
xltoright -> -4161. You find it in VBA Editor: Menu, View, Object Browser (F2.
Or run Excel macro from VFP:
Ex = CreateObject("Excel.Application&quot
Ex.Workbooks.Open("YourXlsWithMacro.xls&quot
Ex.Run('YourXlsWithMacro.xls!ThisWorkBook.NameOfMacro', var1, var2, ....) or without variables.

Regards from Monika (Warszawa - Poland)
(monikai@yahoo.com)

 

[Mike Gagnon]

Take a look at faq184-4266, and faq184-4255 and faq184-4248 to help you with Excel automation.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[iyarosh]

Hello, I'm trying to convert Excel's

Range(Selection, Selection.End(xlToRight)).Select

statement into VFP and running out of ideas; keep getting the errors. Would highly appreciate if some one could give me a hand with the conversion. Thanks in advance!

 

[JRB-Bldr]

iyarosh - a couple of suggestions....

1. Instead of trying to add on to an existing posting on a different specific question, post your own question separately.

2. Post your Excel Automation question on the forum specific to VFP Excel Automation
Microsoft: VFP - Automation, Mail & 3rd Party Svcs Forum
forum1251

3. Tell us what you are trying to accomplish. The Excel VBA code that you posted, by itself, does not give us (at least me) too much help in understanding what you are trying to accomplish. Many times I have found that getting VFP Excel Automation to work involves more than a single line command.

Good Luck,
JRB-Bldr

 

[iyarosh]

JRB-Bldr,

Thank you for the suggestions; I posted my question as a separate thread and added a 'bit more details. This is the link:

http://www.tek-tips.com/viewthread.cfm?qid=922666

Thanks,
iyarosh.