Thread: filter with vb code
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
  
Posts: 593
Default filter with vb code
Nate Oliver wrote:
Note they're speaking to querying an open Excel file.

*You* were suggesting to the OP to query an open Excel file by using
ThisWorkbook.FullName in the connection string.

Jamie.

--

Reply With QuoteReply With Quote