You'll need to write VBA code that opens the workbook, finds the textbox
(IIRC this is done via the worksheet's Shapes collection) and gets the
text (IIRC from its TextFrame).
It's not simple, especially if there are multiple shapes on the
worksheet and you need to relate text from each textbox to values in
nearby cells. You'll need a good understanding of VBA and the Excel
object model.
On Thu, 27 Jul 2006 06:48:02 -0700, bigvoytek
<bigvoytek[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >Is there a way to import data from a text box in Excel into Access? I need to
>find an automated way to do this because I am doing this task for a large
>number of spreadsheets.
>
>Any help would be very appreciated!!
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|