PC Review


Reply
Thread Tools Rate Thread

how to connect Citect VBA with excel spreadsheet?

 
 
nuttynibbles
Guest
Posts: n/a
 
      17th Sep 2004
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

--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      18th Sep 2004
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/
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Program link to Excel spreadsheet opens Excel but not spreadsheet =?Utf-8?B?Y2I=?= Microsoft Excel Crashes 1 11th Feb 2006 02:55 PM
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? oil_driller Microsoft Excel Misc 1 8th Feb 2005 09:34 AM
Macro to save excel XP spreadsheet to excel 97 spreadsheet format Mas Microsoft Excel Programming 1 11th Feb 2004 08:44 PM
Connect to Excel spreadsheet ??? - PART 2 Microsoft ADO .NET 1 30th Dec 2003 03:40 AM
Connect to Excel spreadsheet ??? Microsoft ADO .NET 3 30th Dec 2003 12:12 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:56 AM.