"Rick Schuhr" <rick_schuhr@hotmail.com> wrote in message
news:%23hOaf4ukEHA.1904@TK2MSFTNGP09.phx.gbl...
> All,
>
> I have been away from DTS for some time now and have been asked to step
back
> in and help someone out. However, there are some dynamic steps in the
> ActiveX task script that require that we hide and unhide specific Excel
> columns relative to the initial column insertion point on each worksheet.
> (i.e. We are inserting a new column for the Week-ending metrics and then
> hiding any columns with weekending dates not in the current month)
> FirstColDisplayed=datepart(m,convert(char(8),@eDate120)+'01')
> LastColDisplayed=datepart(wk, @eDate)
>
> Can someone refresh my memory as to the syntax to control the property
from
> ActiveX?
>
> I tried xlSheet.EntireColumn.Hidden = True (Where xlSheet is my connection
> reference in ActiveX that works properly), but it fails.
> I prefer to do this in ActiveX since I already have the global variables
> containing the dates and column numbers for the data insertion points. All
> that is left is to set up the looping construct to hide the remaining
> columns relative to the position of my initial global variables.
>
> Thanks for your help in advance!
>
> Mishka
>
>

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OLaSiUwkEHA.2500@TK2MSFTNGP09.phx.gbl...
> Rick
> Please visit at www.sqldts.com
>
>
> "Rick Schuhr" <rick_schuhr@hotmail.com> wrote in message
> news:%23hOaf4ukEHA.1904@TK2MSFTNGP09.phx.gbl...
> > All,
> >
> > I have been away from DTS for some time now and have been asked to step
> back
> > in and help someone out. However, there are some dynamic steps in the
> > ActiveX task script that require that we hide and unhide specific Excel
> > columns relative to the initial column insertion point on each
worksheet.
> > (i.e. We are inserting a new column for the Week-ending metrics and then
> > hiding any columns with weekending dates not in the current month)
> > FirstColDisplayed=datepart(m,convert(char(8),@eDate120)+'01')
> > LastColDisplayed=datepart(wk, @eDate)
> >
> > Can someone refresh my memory as to the syntax to control the property
> from
> > ActiveX?
> >
> > I tried xlSheet.EntireColumn.Hidden = True (Where xlSheet is my
connection
> > reference in ActiveX that works properly), but it fails.
> > I prefer to do this in ActiveX since I already have the global variables
> > containing the dates and column numbers for the data insertion points.
All
> > that is left is to set up the looping construct to hide the remaining
> > columns relative to the position of my initial global variables.
> >
> > Thanks for your help in advance!
> >
> > Mishka
> >
> >
>
>