delete data from excel without openning it

[Nader]

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!

 

[sebastienm]

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>

 

[Nader]

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]

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.