How to - Delete Rows in Excel from Access

F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How can i delete record from 7000 to 65000 in MS Access Table? 0
Excel Macro for deleting Rows containing dates greater than "today" 0
how to delete rows in linked spreadsheet 4
Delete only Filetered rows in excel 2007 not hidden rows or header 0
Excel Cannot delete empty cells/rows 4
Delete Rows 3
Search for sepcific words and delete rows between them 1
Easiest Way to Delete Rows 4

Top