Programming

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

Enumerate all global variables?
Anyone know if there's a way to enumerate the global variables within a workbook when opening it for automation? I know that you can write a macro in a general module that exposes a variable and then call that macro via: Excel.Application.Run(MacroName) But what if you have no control over the developmen... 19 Jul 2008 09:54

Insert a blank row
This sounds silly, I have a spreadsheet sorted by column I which is text, all i need to do is insert a blank row inbetween the changes. Or If some one could help me figure out another way to undo the remove blank row instruction at the beginning of the code. respectfully, Karl ... 18 Jul 2008 16:31

Alien abduction of VB: "Code execution has been interrupted..."
I have literally hundreds of VB macros that have run flawlessly for years. Suddenly this message started to appear everywhere. I found discussions of the problem in various on-line forums, which report that the problem is not just in Excel, but in Word and Access macros as well. So clearly this phenomenon is a ... 17 Jul 2008 15:49