Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: Please help convert macro code to vfp
Thread ID: 289088 Message ID: 289112 # Views: 35 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Tuesday, December 28, 2010 12:55:18 PM         
   


> > Hi experts,
> > please help me convert this macro code to vfp codes, have no time to search for archives thanks in advance
> >
> > Sheets.Add
> > Sheets("Sheet4").Select
> > Sheets("Sheet4").Move After:=Sheets(4)
>
>
>
> WITH oExcel && Where oExcel is your Excel.Application instance
>     .Sheets.Add()
>     .Sheets("Sheet4").Select
>     .Sheets("Sheet4").Move(null,.Sheets(4))
> ENDWITH
> 

> (not tested)
> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.

For future reference, how did you do that? Do you have a technique for converting all the non-trivial macros to VFP for automation?

ENTIRE THREAD

Please help convert macro code to vfp Posted by Bert Murillo @ 12/28/2010 9:54:12 AM
RE: Please help convert macro code to vfp Posted by Borislav Borissov @ 12/28/2010 10:06:39 AM
RE: Please help convert macro code to vfp Posted by Bert Murillo @ 12/28/2010 10:54:09 AM
RE: Please help convert macro code to vfp Posted by Russell Hill @ 12/28/2010 12:53:21 PM
RE: Please help convert macro code to vfp Posted by Russell Hill @ 12/28/2010 12:55:18 PM
RE: Please help convert macro code to vfp Posted by Samir H. @ 12/28/2010 1:20:43 PM
RE: Please help convert macro code to vfp Posted by Borislav Borissov @ 12/28/2010 1:31:25 PM
RE: Please help convert macro code to vfp Posted by Cetin Basoz @ 12/28/2010 3:56:35 PM
RE: Please help convert macro code to vfp Posted by Russell Hill @ 12/28/2010 8:54:32 PM