home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,702 of 9,834   
   Robert Wiltshire to All   
   Re: Setting OleAuto variables to sub-obj   
   17 Apr 09 22:07:56   
   
   From: nomail@nospam.com   
      
   I tried to put this in terms I have dealt with,   
   and was stumped too.   
      
   I took a working example from using the excel oleauto stuff   
      
   var   
    oaExcel,oaActiveSheet,oaCells  oleAuto   
    stTag string   
   endvar   
      
   xlslib.ExcelOpen(oaExcel)   
   oaActiveSheet = oaExcel.ActiveSheet   
   oaCells            = oaActiveSheet.cells   
      
      
   That code worked in the context I pulled it from,   
   and when I tried to do to put the "cells"   
   into a string...I hit the wall also.   
      
   xlslib.ExcelOpen(oaExcel)   
   oaActiveSheet = oaExcel.ActiveSheet   
   stTag = "cells"   
      
   none of these worked   
   oaCells  = oaActiveSheet.stTag   
   oaCells  = oaActiveSheet.(stTag)   
   oaCells = oaActiveSheet^stTag   
   oaCells = oaActiveSheet^(stTag)   
      
   The only thing that comes to my mind right now is,   
   to build some code on the fly,   
   and use methodset and execmethod   
   or possibly executestring.   
      
   There were examples of first/next and collection objects in the opal help.   
   I am not sure if that is approriate for your situation.   
      
   Is the control you are working on a publicly available control ?   
   If I had it on my system,   
   I might try to help brainstorm/pursue that a little bit further.   
      
   Another idea, perhaps Vladimir still sells an oleauto tool.   
      
      
   Good luck   
   Robert Wiltshire   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca