delete data from excel without openning it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nader - 28 Nov 2007 18:04 GMT

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!

Reply to this Message

sebastienm - 28 Nov 2007 19:02 GMT

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>

Signature

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

> Hello,
>
[quoted text clipped - 6 lines]
>
> Cheers!

Reply to this Message

Nader - 29 Nov 2007 13:52 GMT

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!

> Hi,
> If your worksheet is orgaized as a table (database), you should be able to
[quoted text clipped - 18 lines]
>>
>> Cheers!

Reply to this Message

sebastienm - 29 Nov 2007 17:14 GMT

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.

Signature

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

> Hello Sébastien,
>
[quoted text clipped - 26 lines]
> >>
> >> Cheers!

Reply to this Message