ActiveX script in DTS to Autofilter on a Protected worksheet

FAQ

Profile

ActiveX script in DTS to Autofilter on a Protected worksheet

Database Help (Home) -> DTS

Next: form showing old session values after submission

Author

Message

External

Since: Nov 05, 2008
Posts: 1

(Msg. 1) Posted: Wed Nov 05, 2008 2:58 pm Post subject: ActiveX script in DTS to Autofilter on a Protected worksheet Archived from groups: microsoft>public>sqlserver>dts (more info?)

Could anyone please assist? I need to have Autofilter on a Protected Excel worksheet, but I can't seem to get it working. I know the same thing can be done in Excel itself (Set the Autofilter, then Tools, Protection, Protect Sheet, Enable Autofilter), but I need to do it in programmatically, using an ActiveX Script task in DTS. Have tried using the code below which shows the Autofilter in the Excel, but I can't use, doesn't allow me to click on the drop-down arrows. xl.ActiveSheet.Range("A1","F1").AutoFilter xl.ActiveSheet.Protect >> Stay informed about: ActiveX script in DTS to Autofilter on a Protected worksheet

Display posts from previous:

Related Topics:

ActiveX Script in DTS Package - I have a DTS package that has the ActiveX Script code listed below that is used to call stored procedures in SQL Server database. The DTS package and database correspond to SQL Server 2000. Please help me find documentation that corresponds to the cod...

Question on Activex script in DTS - I'm trying to bring over a text file into a SQL table, and the data has got what appears to be low values in a field on it. It's causing a problem when I try to load them into a table though. It doesn't set it to spaces (which I am looking for later....

Sending Email using ActiveX Script task - In my SQL Server 2000 DTS package i need to send e-mails to the list of recipient. I am using xp_smtp_sendmail stored procedure. When i send email to unavailable recipient i need to bounce back the e-mail to the sender. But when i use the stored..

Login Failed Error in ActiveX script in DTS! - Hi I have one ActiveX Script task and VB script written in it is : Function Main() dim SQLConn dim Sql dim RS set SQLConn = CreateObject("ADODB.Connection") RS = DTSGlobalVariables("SEASON").value SQLConn.Open = "Provi...

DTSHelper ActiveX DLL - I extracted some VB script from the WROX book "SQL Server 2000 DTS" to get error information. The rest of the script works fine. The problem segment gets a readble form of the error. How to fix this? The error message I get is: Error Co...

	Database Help (Home) -> DTS	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum