Programming

Month and Year in Excel 2003
I'd like to have a column that displays incremental month and year (no day). How do I do this? ... 21 Jul 2008 09:58

Personal.xls macro that writes to ThisWorkBook
I've writen a macro that only runs when my user needs to run the marco. Here is what the marco does: 1) User opens a SAP report which needs to be formated. 2) User runs my macro to format the report 3) Macro also creats a PivotTable on worksheet "Discounts". 4) User might need to update one of the fields in Data ... 18 Jul 2008 13:24

Alien abduction of VB: "Code execution has been interrupted...
I would however take note of this snippet from VBA Help on topic EnableCancelKey Property: "Remarks Use this property very carefully. If you use xlDisabled, there's no way to interrupt a runaway loop or other non – self-terminating code. Likewise, if you use xlErrorHandler but your error handler always returns ... 30 Jul 2008 22:02

2007 vs 2003
I have a few questions on excel 2007 vs 2003. I only have 2003. So if I check application.version I have 11.0. Is 2007 12? How can you tell what version an excel doc is? Just by extension? Or something else? Is there ways that a 2007 document could be saved as 2003 document with its 2007 extension? Or... 17 Jul 2008 18:55

How to? Date Function
I have a date in a table that is in the format 20080620. (Year Month Day all together). Is it possbile to make execl convert this into a format I could use in the DAY360 function? Thanks! ... 18 Jul 2008 15:28

Code interrupted
I have the following code and everytime I run it I get a debugger message that says the code is interrupted. I'm not sure how to correct this. Can anyone help? Sub COPY() ' ' COPY macro ' 'select area and clear Range("C6").Select Range(Selection, Selection.End(xlDown)).Select Selection.Cle... 31 Jul 2008 16:31

finding data across multiple ws to populate a userform (Need H
When I do this joel I get the debugger. It highlights the line Set ws = Sheets("Sheet_") with the _ being whatever page corresponds to the zip code entered. Thank you for helping. "Joel" wrote: If tbZipCode.Value < 20000 Then Set ws = sheets("Sheet1") ElseIf tbZipCode.Value < 40000 Then ... 17 Jul 2008 22:00

get the name of the currently active procedure?
Is there a way to programatically get the name of the currently active procedure? (sub or function, and the module in which it resides) thanks, Harry ... 17 Jul 2008 18:55

Comparing data in cells
I've got some experience with VBA in Access but I am new to Excel VBA. My customer provides me with large spreadsheets for each revision of a product I build for them. They frequently make minor changes to one or two of the records which places me in the position of comparing line for line, cell for cell to f... 17 Jul 2008 17:53

Error in Workbook_Open
Hello, I have an excel file that I get as an attachment everymonring with a table in it. Every monring I save the attachment over the previous day's file. If I open the document and then open the VB editor in the project explorer on the left, there is two projects the first I believe Personal.xls and the sec... 18 Jul 2008 10:18