How to - Delete Rows in Excel from Access

[Filo]

Hello-
I am having problems determining how to delete rows in an excel worksheet
from Access. I tried

xlwb.Sheets("Data_Source").Rows(3 & ":" & 65000).Delete

but it gives me a type mismatch error.

Thank you.

Filo

 

[Alex Dybenko]

Hi,
try:

xlwb.Sheets("Data_Source").Rows(3 & ":" & 65000).Range.Delete

You can also run excel macro editor to find out what VBA code Excel uses

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com