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!