Transfering Values from OLE Objects to a Textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top