Programming

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

How to get source range from chart object?
Does any one know how to get the source range used to create the chart?? thanks in advance! ... 17 Jul 2008 15:49

can a userform be 'locked' into position
can a userform be 'locked' into position once displayed? thanks ... 17 Jul 2008 18:55

using border/usedrange in vba
hi all. I have a macro that I want to work through a worksheet, with specific criteria. At this point, borders seem to be the common property. My goal is to have this macro look for some property that determines a start point (since the borders are the most common property on our worksheets, they seemed th... 17 Jul 2008 14:46

confused and confounded!
I created a macro, with some help here, and sent it to another office across the state. When she tries to run it on that computer, she gets a runtime error that it doesn't recognize the object on this line: Set wbTribal = Workbooks("Tribal template.xls") wbTribal is dimmed as a workbook. The workbook is "Tri... 18 Jul 2008 11:20

Hide/Unhide Toggle
Greetings All: Looking to control some large spread-sheets (SS) by the use of hide/unhide toggles. The application is such that on the larger "groupings" in the SS, the user can "collapse" that grouping if it is not needed, in order to "shorten" the SS. In order to determine if my application is feasible... 17 Jul 2008 15:49

Macros Disabled in Excel 2007
I have converted a file from Excel 2003 to Excel 2007 (SP1). In the file I have a print macro assigned to a buttom that goes through a For Next Loop to print some reports from employees. I try to run the Macro and get a message - "Because of security settings, macros have been disabled. To run macros, you nee... 17 Jul 2008 16:51

need a macro to edit names in excel
I'd like to create (or use someone else's) a macro to edit names in Excel spreadsheets. I need a.) to remove the last name and comma from a last-name-first listing, and b.) to remove the comma and first name from a last-name-first listing. In a.) that would leave the cell with only the first name remaining, an... 17 Jul 2008 14:46