1.Select your range 2.Insert / Name / Define 3.Type the name your want 4.Click Add 5.Ok out and save your .xls
I seem to remember the named ranges being a little tricky so you may need to play around with it. Eric ----- Original Message ----- From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 4:52 PM Subject: RE: Dynamic connection to an excel file. Dude, How do I define a "named excel range"? -mk -----Original Message----- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:10 PM To: CF-Talk Subject: Re: Dynamic connection to an excel file. I forgot about this question >Secondly, once I connect successfully - what do I use to query with? Is it "sheet1" or workbook1.sheet1 or ... what? Any clues are helpful. Thanks! When I'm connecting from ASP I just run queries like it's a sql table. where table = Excel Named range Eric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4