Naming a range

[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

 

[Jan Karel Pieterse]

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