Output text to excel textbox

  • Thread starter Thread starter dandgard
  • Start date Start date
D

dandgard

I have a need to output a memo field to an embedded textbox on an exce
worksheet.

Can anyone tell me what the syntax is to access the textbox on th
excel from an an Access vba procedure. I have set up the code to ope
the right workbook and sheet and have no problem with accessing th
sheet itself.

I have been able to look at some of the properties by usin
sheetcontrol.Shapes(x) but everytime i try to read or write the text t
the textbox i get the message that it doesn't support this property
 
dandgard said:
I have a need to output a memo field to an embedded textbox on an excel
worksheet.
Click to expand...

Rather than automating your Excel workbook from MS Access, you may
find it easier (definitely faster) to get the Excel workbook to fetch
the Memo data itself i.e. no automation required, could use ADO in
Excel VBA code.

--
 
Back
Top