If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Naming a range
I trying to setupa frontpage file that sends data from a
form to microsoft excel file. Every time I try to do this I am told that the microsoft excel referenced by the DB connection does not containe a named range of cells and that the database driver does not recognise a databse table. I would be grateful if someone could inform hot to set-up a named range. Thanks Nick Read |
#2
|
|||
|
|||
Naming a range
Hi Nick,
I would be grateful if someone could inform hot to set-up a named range. Select the range of cells that contains your data, choose Insert, name, define and enter a name, preferably "Database" (without the quotes). Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Thread Tools | |
Display Modes | |
|
|