Thread: Creating recordsets based on a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PO PO is offline
external usenet poster
  
Posts: 66
Default Creating recordsets based on a range
Hi

How do I create a recordset from a range (A1:G100) or named range (Adress,
referes to A1:G100)?

I´ve tried

rs.open("SELECT * FROM Adress")

but what is the ActiveConnection?

Regards
PO


Reply With QuoteReply With Quote