delete data from excel without openning it
 

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!

delete data from excel without openning it
 

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!

delete data from excel without openning it
 

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!

delete data from excel without openning it
 

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!