how to connect Citect VBA with excel spreadsheet?

  • Thread starter Thread starter nuttynibbles
  • Start date Start date
N

nuttynibbles

i am suppose to read a value from an Excel Spreadsheet then print th
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?

than
 
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/
_______
 
Back
Top