By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,289 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,289 IT Pros & Developers. It's quick & easy.

Excel Automation Problem

P: n/a
I currently have an Excel spreadsheet with numerous text boxes and check
boxes that I want to populate with data from an Access 97 database. I have
used Excel automation in Access before but only to update cells not controls
like text boxes.

Can someone steer me onto the correct path? I am not using a VBA form in
Excel it is just merely various text boxes and checkboxes placed on a
worksheet.
Any help would be much appreciated.
Regards,
Mark
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You can use alt-F11 to display the VBE pane for your spreadsheet. There are
two dropboxes at the top of the right-hand pane - the left-most one has a
list of all the objects (including text boxes and check boxes) on your
spreadsheet. You should be able to get the names of your objects from
there.

HTH
- Turtle

"Mark C" <he******@yahoo.com> wrote in message
news:Y6********************@comcast.com...
I currently have an Excel spreadsheet with numerous text boxes and check
boxes that I want to populate with data from an Access 97 database. I have
used Excel automation in Access before but only to update cells not controls like text boxes.

Can someone steer me onto the correct path? I am not using a VBA form in
Excel it is just merely various text boxes and checkboxes placed on a
worksheet.
Any help would be much appreciated.
Regards,
Mark

Nov 13 '05 #2

P: n/a
I understand that, but how do I reference the Excel control from Access.
Normally I would write some kind of statement like
worksheet1.Range(A1).value = rst!fieldname.

If I try that with a control name I get an error. I am trying to find out
how to reference the Excel control in this line of code.

Mark


"MacDermott" <ma********@nospam.com> wrote in message
news:AY****************@newsread3.news.atl.earthli nk.net...
You can use alt-F11 to display the VBE pane for your spreadsheet. There
are
two dropboxes at the top of the right-hand pane - the left-most one has a
list of all the objects (including text boxes and check boxes) on your
spreadsheet. You should be able to get the names of your objects from
there.

HTH
- Turtle

"Mark C" <he******@yahoo.com> wrote in message
news:Y6********************@comcast.com...
I currently have an Excel spreadsheet with numerous text boxes and check
boxes that I want to populate with data from an Access 97 database. I
have
used Excel automation in Access before but only to update cells not

controls
like text boxes.

Can someone steer me onto the correct path? I am not using a VBA form in
Excel it is just merely various text boxes and checkboxes placed on a
worksheet.
Any help would be much appreciated.
Regards,
Mark


Nov 13 '05 #3

P: n/a
Sorry!
It's coming back to me slowly...
Those controls on Excel are quite difficult to reference externally.
(In fact, I think they're difficult to reference internally, too.)
The best I've done (AFICR) is to link your textbox (or checkbox) to an Excel
cell, then programmatically put the value in the cell.
If the control is big enough, you can "hide" the linked value in a cell
directly under it; otherwise you can use a separate sheet if you like.

HTH

"Mark C" <he******@yahoo.com> wrote in message
news:0u********************@comcast.com...
I understand that, but how do I reference the Excel control from Access.
Normally I would write some kind of statement like
worksheet1.Range(A1).value = rst!fieldname.

If I try that with a control name I get an error. I am trying to find out
how to reference the Excel control in this line of code.

Mark


"MacDermott" <ma********@nospam.com> wrote in message
news:AY****************@newsread3.news.atl.earthli nk.net...
You can use alt-F11 to display the VBE pane for your spreadsheet. There
are
two dropboxes at the top of the right-hand pane - the left-most one has a list of all the objects (including text boxes and check boxes) on your
spreadsheet. You should be able to get the names of your objects from
there.

HTH
- Turtle

"Mark C" <he******@yahoo.com> wrote in message
news:Y6********************@comcast.com...
I currently have an Excel spreadsheet with numerous text boxes and check boxes that I want to populate with data from an Access 97 database. I
have
used Excel automation in Access before but only to update cells not

controls
like text boxes.

Can someone steer me onto the correct path? I am not using a VBA form in Excel it is just merely various text boxes and checkboxes placed on a
worksheet.
Any help would be much appreciated.
Regards,
Mark



Nov 13 '05 #4

P: n/a
Please see response in
comp.databases.ms-access

"Mark C" <he******@yahoo.com> wrote in message
news:0u********************@comcast.com...
I understand that, but how do I reference the Excel control from Access.
Normally I would write some kind of statement like
worksheet1.Range(A1).value = rst!fieldname.

If I try that with a control name I get an error. I am trying to find out
how to reference the Excel control in this line of code.

Mark


"MacDermott" <ma********@nospam.com> wrote in message
news:AY****************@newsread3.news.atl.earthli nk.net...
You can use alt-F11 to display the VBE pane for your spreadsheet. There
are
two dropboxes at the top of the right-hand pane - the left-most one has a list of all the objects (including text boxes and check boxes) on your
spreadsheet. You should be able to get the names of your objects from
there.

HTH
- Turtle

"Mark C" <he******@yahoo.com> wrote in message
news:Y6********************@comcast.com...
I currently have an Excel spreadsheet with numerous text boxes and check boxes that I want to populate with data from an Access 97 database. I
have
used Excel automation in Access before but only to update cells not

controls
like text boxes.

Can someone steer me onto the correct path? I am not using a VBA form in Excel it is just merely various text boxes and checkboxes placed on a
worksheet.
Any help would be much appreciated.
Regards,
Mark



Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.