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


> >
> >
> >
> > 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?

No, But the Excel Macro Help shows you the Method syntax and the positions of the parameters.
You can't use named parameters as it is in Excel, but you can use positioned parameters.


-----------------
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.

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