Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 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: 289113 # Views: 36 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Tuesday, December 28, 2010 1:20:43 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?


I guess you know this, but I still post it, since you asked...

Note the tooltips, once you declared oX as a excel.application:



Regards
Samir

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