Programming

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

Locking / Unlocking Cell with out Protection/ Unprotection of Shee
Dear all, Presently, I am doing a VB Coding for a Worksheet in which I want to control the sheet. I just want to know if there is any possibility of locking or unlocking the cells with out Unprotect/Protect Commands. For example, In Cell A1, if I select "Boiler"(from drop down list), then Cells A2,A3 and A4 sho... 18 Jul 2008 09:15

Select Worksheets, Copy to New Workbook
I have a worksheet that is used as a processing template and then I want to copy specified worksheets to a new file for distribution without any macros attached. However, the code I'm using isn't working despite it being used successfully by other posters here. Obviously, I'm doing something wrong and would app... 18 Jul 2008 11:20

Why are my Add-In formulas recalculating everytime I open a workbo
I know that Excel has smart logic built in to recalculate formulas when it needs to and that you can manually have it calculate even if nothing has changed, but is it supposed to recalc unchanged cells on open of an XLS file? As a test, I created a VBA module (see test code below) and saved the project as an X... 18 Jul 2008 09:15