Posted to microsoft.public.excel.programming

Nexus

external usenet poster

Posts: 5

Excel Automation problem with AutoFilters

I've developed a VB application that does some OLE Automation using Excel.

I want to check that there is no autofilter currently active and that all
rows are shown (but still keep the AutoFilter enabled).

The code to this is within a VBA macro is

Activesheet.ShowAllData

(I believe)

However when I try to do this within VB e.g

Dim X as New Excel.Application
.......
X.ActiveSheet.ShowAllData

I get object does not support method.

Any ideas what I am doing wrong?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel automation problem	Arvi Laanemets	Excel Programming	3	April 13th 06 09:22 AM
Excel Automation Problem With Add-Ins	pagates	Excel Programming	4	October 6th 05 05:18 PM
Problem in graph automation in excel.	news.microsoft.com[_7_]	Excel Programming	3	April 30th 05 06:02 AM
TypeConverter Excel-Automation problem	Markus	Excel Programming	0	August 23rd 04 11:17 AM
Userforms and autofilters - Autofilters don't seen to work with userform	No Name	Excel Programming	3	August 28th 03 05:42 PM

All times are GMT +1. The time now is 07:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us