Hello,

I've got a huge file from which i'd like to delete to some rows but I DO NOT
WANT TO OPEN IT in order to avoid having to wait a long time. So, is it
possible to delete some data (using vba) from an excel file without openning
that file?

Thanks in advance.

Cheers!

Hi,
If your worksheet is orgaized as a table (database), you should be able to
by using ADO. However the excel driver is a bit buggy, so you have to be
carefull.
Look at the following msdn articles and the articles they are referencing at
the bottom.
-<http://support.microsoft.com/kb/257819>
-<http://support.microsoft.com/kb/278973>

--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"Nader" wrote:

> Hello,
>
> I've got a huge file from which i'd like to delete to some rows but I DO NOT
> WANT TO OPEN IT in order to avoid having to wait a long time. So, is it
> possible to delete some data (using vba) from an excel file without openning
> that file?
>
> Thanks in advance.
>
> Cheers!
>
>
>

Hello Sébastien,

Thanks for the articles but unfortunately it seems that I can only delete
values and not formulas.
Also, I cannot delete an entire row.

Cheers!

"sebastienm" <(E-Mail Removed)> a écrit dans le message
de news: 476590DE-B6C6-4D22-BF05-(E-Mail Removed)...
> Hi,
> If your worksheet is orgaized as a table (database), you should be able to
> by using ADO. However the excel driver is a bit buggy, so you have to be
> carefull.
> Look at the following msdn articles and the articles they are referencing
> at
> the bottom.
> -<http://support.microsoft.com/kb/257819>
> -<http://support.microsoft.com/kb/278973>
>
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>
>
>
> "Nader" wrote:
>
>> Hello,
>>
>> I've got a huge file from which i'd like to delete to some rows but I DO
>> NOT
>> WANT TO OPEN IT in order to avoid having to wait a long time. So, is it
>> possible to delete some data (using vba) from an excel file without
>> openning
>> that file?
>>
>> Thanks in advance.
>>
>> Cheers!
>>
>>
>>
>

Yes, it is pretty limited and only applies to db-table-like sheets.
As far as I know, that's the only access you have to a CLOSE workbook.
Maybe there are ways with xl2007 and its OpenFormat xml format, but that
would be for 2007 only.
Sorry, I have no other idea.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"Nader" wrote:

> Hello Sébastien,
>
> Thanks for the articles but unfortunately it seems that I can only delete
> values and not formulas.
> Also, I cannot delete an entire row.
>
> Cheers!
>
> "sebastienm" <(E-Mail Removed)> a écrit dans le message
> de news: 476590DE-B6C6-4D22-BF05-(E-Mail Removed)...
> > Hi,
> > If your worksheet is orgaized as a table (database), you should be able to
> > by using ADO. However the excel driver is a bit buggy, so you have to be
> > carefull.
> > Look at the following msdn articles and the articles they are referencing
> > at
> > the bottom.
> > -<http://support.microsoft.com/kb/257819>
> > -<http://support.microsoft.com/kb/278973>
> >
> > --
> > Regards,
> > Sébastien
> > <http://www.ondemandanalysis.com>
> >
> >
> > "Nader" wrote:
> >
> >> Hello,
> >>
> >> I've got a huge file from which i'd like to delete to some rows but I DO
> >> NOT
> >> WANT TO OPEN IT in order to avoid having to wait a long time. So, is it
> >> possible to delete some data (using vba) from an excel file without
> >> openning
> >> that file?
> >>
> >> Thanks in advance.
> >>
> >> Cheers!
> >>
> >>
> >>
> >
>
>
>