Thread: Select from first worksheet without knowing it's name
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Roger Twomey Roger Twomey is offline
external usenet poster
  
Posts: 3
Default Select from first worksheet without knowing it's name
:) 'Eek!' is not a problem. Because the spreadsheet is loaded to a remote
server first, they cannot open it in excel. The circumstances required for
the memory leak cannot occur.

Thanks for the heads up though. I would not likely have known of the issue
otherwise.

"onedaywhen" wrote in message
om...
Is there some function or code that can be used in place of:

strExcelSQL = "SELECT * FROM [Sheet1$]"

"Don Guillett" wrote in message
...
try

Sheets(1).Activate

Eek!

BUG: Memory Leak Occurs When You Query an Open Excel Worksheet Using ADO
http://support.microsoft.com/default...;en-us;Q319998

--


Reply With QuoteReply With Quote