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" a écrit dans le message
de news: ...
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!