Programming

.SendMail how do you turn off Alert "This program is trying to send...
I want this automated without having to wait? Thanks ... 18 Jul 2008 11:20

Insert rows without copying borders and shading
I am coding a sheet in which I need to insert multiple rows and I have a function that I can call that does this splendidly. The problem arises if you have a row with shading and borders ABOVE the row on which you are doing an insert, then the borders and shading from the row above is copied down when the inser... 21 Jul 2008 05:52

Unable to get the PivotItem Property of the Pivotfield Class
I get this error when I try to use VBA to modify the selections on a pivot table chart. Any idea why? ... 18 Jul 2008 14:26

Routing slips in Excel 2007
Does Excel 2007 have a method that replaces the routing slip method in Excel 2003? ... 18 Jul 2008 11:20

Conditional Macro
I'd like to create a macro that will print either sheet #1, #2, #3, #4 or #5 based on the value in a particular cell. Thanks, Larry ... 18 Jul 2008 13:24

Locking / Unlocking Cell with out Protection/ Unprotection of
Dear John, Thanx for your reply. The reason for a big password is that nowadays many password crackers are available. Hence as it is an important spread sheet, i want to give characters of upto 43.Because even though if they use password cracker, it will take at least 15 - 20 minutes for unlocking the password. ... 18 Jul 2008 10:18

Internet Explorer Automation through vba.
Hi, Can any one help me to automate the internet explorer object through vba excel.. thanks in advance.. regards. Lucky ,,,, ... 18 Jul 2008 23:42

Why are my Add-In formulas recalculating everytime I open a wo
Yes, but it states: "Excel will automatically recalculate all open workbooks at each and every change, and whenever you open a workbook. Usually when you open a workbook in Automatic mode and Excel recalculates you will not see the recalculation because nothing will have changed since the workbook was saved." ... 18 Jul 2008 11:20

Creating Name with variable
Hi there, I am trying to create Names with the following statement: ActiveWorkbook.Names.Add Name:="vld" & sVldName, RefersTo:=vldFormula I keep getting the runtime error 1004. I will appreciate if somebody would help me getting round this probelm. -- Thanx & regards, Asif ... 18 Jul 2008 14:26

How to get access 2003 data table particular data in excel.
How thru macro we can get access 2003 data table particular data in excel worksheet. -- Anupam ... 18 Jul 2008 10:18