Prev: custom columns for WKS
Next: Forms Authentication
From: Amey on 27 Jan 2010 01:33
Dear sir ,

I have just started learning macros.I want to creat a macro for "
Late " activities in the "Status " column. When I complete the procedure and
go to VBE , there the steps end at Autofilter.It just creats filter but next
procedure it doesn't take.Even if when I write
Autofilter
Selecttaskcolumn column:="status"
FilterApplyName= "Late"

Even then it just inserts filter but doesn't filter " Late" in "status"
column.It doesnt show any debug message also. So what I need to do for it.
--
Amey B. Vidvans,
Planning Engineer
Vidvans_amey(a)rediffmail.com
From: Rod Gill on 27 Jan 2010 04:47
Hi,

Try recording a macro of you manually doing what you want. The recorded code
may provide everything you need or at least a great start. Record thru
Tools, macro, record new macro exactly the same as in Excel.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




"Amey" <Amey(a)discussions.microsoft.com> wrote in message
news:64C79146-C0DB-4CFC-9E92-B6479F535C58(a)microsoft.com...
> Dear sir ,
>
> I have just started learning macros.I want to creat a macro for "
> Late " activities in the "Status " column. When I complete the procedure
> and
> go to VBE , there the steps end at Autofilter.It just creats filter but
> next
> procedure it doesn't take.Even if when I write
> Autofilter
> Selecttaskcolumn column:="status"
> FilterApplyName= "Late"
>
> Even then it just inserts filter but doesn't filter " Late" in "status"
> column.It doesnt show any debug message also. So what I need to do for it.
> --
> Amey B. Vidvans,
> Planning Engineer
> Vidvans_amey(a)rediffmail.com
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4808 (20100126) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4808 (20100126) __________

The message was checked by ESET Smart Security.

http://www.eset.com



 | 
Pages: 1
Prev: custom columns for WKS
Next: Forms Authentication