Naming a range

N

Nick Read

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
 
J

Jan Karel Pieterse

Hi Nick,
I would be grateful if someone could inform hot to set-up
a named range.
Click to expand...

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
 
Top