Transfering Values from OLE Objects to a Textbox

O

OC Del Guy

I have a table with an Excel spreadsheet as an object and a textbox formatted
as currency. Without using VB Code, is there a way to make the textbox the
value of one of the cells in the worksheet?
Say for example, The worksheet has a cell which has the sum of several
numbers. I need the textbox to display the same number. Is this possible?
 
S

Stephen Lebans

NO, not without some code.
You would have to Activate the Excel object and then use Automation to
access the desired Worksheet and copy over the cell's contents. It's not
that complicated and a GoogleGRoups search would yiled sample code to
get you started.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top