Re: Select from first worksheet without knowing it's name
From: onedaywhen (onedaywhen_at_fmail.co.uk)
Date: 05/04/04
- Next message: DavidW: "Adding Pivot Tables Dynamically"
- Previous message: Steve Garman: "Re: Cycle Number Lock"
- In reply to: Don Guillett: "Re: Select from first work*** without knowing it's name"
- Next in thread: Roger Twomey: "Re: Select from first work*** without knowing it's name"
- Reply: Roger Twomey: "Re: Select from first work*** without knowing it's name"
- Messages sorted by: [ date ] [ thread ]
Date: 4 May 2004 01:13:17 -0700
> > Is there some function or code that can be used in place of:
> >
> > strExcelSQL = "SELECT * FROM [Sheet1$]"
"Don Guillett" <donaldb@281.com> wrote in message news:<OtvlS0TMEHA.3420@TK2MSFTNGP11.phx.gbl>...
> try
>
> Sheets(1).Activate
Eek!
BUG: Memory Leak Occurs When You Query an Open Excel Work*** Using ADO
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319998
--
- Next message: DavidW: "Adding Pivot Tables Dynamically"
- Previous message: Steve Garman: "Re: Cycle Number Lock"
- In reply to: Don Guillett: "Re: Select from first work*** without knowing it's name"
- Next in thread: Roger Twomey: "Re: Select from first work*** without knowing it's name"
- Reply: Roger Twomey: "Re: Select from first work*** without knowing it's name"
- Messages sorted by: [ date ] [ thread ]
