If CitectVBA is truly VBA, you can set an object variable to the Excel application, and navigate
Excel's object model through that variable. I have a few examples showing how to use Excel to
run other programs and vice versa on this page:
http://peltiertech.com/Excel/XL_PPT.html
If CitectVBA uses VBA the way it is intended to be used, you should be able to make it work. I
have used non-Microsoft VBA servers in this way without a problem (except, of course, for
inadequate documentation).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
nuttynibbles < wrote:
> i am suppose to read a value from an Excel Spreadsheet then print the
> value in Citect page.
>
> whenever i try to print the value in Citect, it appear to be blank.
> i believe Citect is not reading from the Excel spreadsheet.
>
> How can i read the value from Excel then Print it in Citect?
> Cicode and CitectVBA which one should i use to code my program?
>
> thanx
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>