Hi Group,
Ihave to create a ADD-IN to use advancefilter on a database structure created
on a excel workbook.
Can it be done, by placing the database sheet within the add-in workbook?
If not, then can we use a macro to use advance filters on a worksheet which is
present in another workbook?
Pl
Its a good example for learning.
Can you share any links or resource from where one can learn, how to use this
'shell object', in a more advanced way?
Thanks
Harpreet gujral
Sent on my BlackBerry® from Vodafone Essar
-Original Message-
From: rf1234 rf1234
Date: Thu, 4 Mar
#x27;'''''''''''''''''''''''''''''''''''''''''''''''''
Hi shyam,
Actually I am very new to excel VBA, I have seen some codes which use shell
object in order to make use of some other application. Idea is to learn how to
use shell object
Harpreet gujral
Sent on my BlackBerry® from Vodafone Essar
-Original Message-
From: rf1234 rf1234
Date
have access to complete information on Commandbars, and
> all its properties.
>
> Please forward it to me
>
> Thanks
>
> Harpreet Gujral
>
>
> On Feb 21, 7:56 pm, Harpreet Singh Gujral
> wrote:
> > Hi,
> >
> > Can someboday help me with the commandbars?
&
style.can we change it?
>
> The solution provided is good to use if we don't want to give a specific
> name to the range in question.
>
> Regards
>
> Harpreet Gujral
>
> Sent on my BlackBerry® from Vodafone Essar
> --
> *From: *
don't want to give a specific name
to the range in question.
Regards
Harpreet Gujral
Sent on my BlackBerry® from Vodafone Essar
-Original Message-
From: rf1234 rf1234
Date: Thu, 25 Feb 2010 10:58:18
To:
Cc:
Subject: Re: $$Excel-Macros$$ Named Ranges
'Named ranges a