$$Excel-Macros$$ ADD-IN for retriving information from another sheet

2010-09-07 Thread Harpreet Gujral
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

Re: $$Excel-Macros$$ Shell Object

2010-03-04 Thread Harpreet Gujral
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

Re: $$Excel-Macros$$ Data in variables

2010-03-04 Thread Harpreet Gujral
#x27;'''''''''''''''''''''''''''''''''''''''''''''''''&#

Re: $$Excel-Macros$$ Shell Object

2010-03-04 Thread Harpreet Gujral
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

Re: $$Excel-Macros$$ Re: Application.commandbars

2010-02-25 Thread Harpreet Gujral
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? &

Re: Fwd: $$Excel-Macros$$ Named Ranges

2010-02-25 Thread Harpreet Gujral
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: *

Re: $$Excel-Macros$$ Named Ranges

2010-02-24 Thread Harpreet Gujral
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