Programming

Excel 2000 to 2003
when I try to run a solution that was created in Excel 2000 in the Excel 2003, I had the Error "excel.exe application error", "unknow software exception in 0xc0000409 0x30489b99"... Somebody know what is happening? ... 6 Feb 2006 10:29

Formula to calculate military time into hrs
ie; 2300-0015 1.5 hrs ... 4 Feb 2006 23:09

why does userform close after programming worksheet event with CreateEventProc or AddFromString
I have a problem that I hope someone might be able to help with. Thanks in advance for any help. Background: For an excel project, I have created a userform that runs automatically upon opening the workbook. To simplify the example, let's say the userform contains only a textbox and commandbutton controls. The... 4 Feb 2006 17:28

operating notepad from VBA
hello, how can i 1. open notepad, shell ? 2. paste excel range as value into notepad 3. save notepad as html 4. close notepad ? or do it with create object ? thank for suggestion. rgs ... 4 Feb 2006 05:25

creating a small array from spreadsheet values/counts
Hi, I need to create an array in VBA and then perform a MEDIAN function on it. The data in the sheet which will be used to create the array is as follows: A B 2 1 3 2 1 3 2 4 3 5 Column B refers to a VALUE, Column A refers to the COUNT of the number of instance of that value i... 7 Feb 2006 08:53

code execution has been interrupted
Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveWorkbook.Save End Sub I put this code into a shared workbook, so the workbook will be saved whenever a person makes any change. But this code always generate an error "code execution has been interrupted" and it stops at the "End Sub". ... 2 Feb 2006 07:06

Macro to Refresh Data & Print
Hi all, I have a small problem.....I am currently using Excel to import some external data from an Oracle database. As this is a report, the process needs to be automated, hence I need a macro. I need to generate a macro which refreshes the data in the worksheet, then prints the report out and closes the workboo... 1 Feb 2006 16:40

Ever been here?
I am looking to open one of my workbooks (WB1) when an e-mail with ?JJJ? in the subject is received. WB1 will use a second workbook (WB2), attached to the e-mail, as input. So basically what I need to know how to do is: 1) Automatically open an .xls file received in an e-mail. 2) Open a different .xls file in a sp... 15 Feb 2006 17:05

run a macro in a protected sheet
I use Excel 2002 I created a workbook of 12 sheets, and potected each sheet with a password with Autofilter enabled. To Show all Data after filtering, I created a button on each sheet with a command Click event as follows: If ActiveSheet.FilterMode = True Then ActiveSheet.ShowAllData Else ... 4 Feb 2006 13:50

ChangeLink Command Not Working
I have a situation where I am copying files from a "common files" folder into individual folders. Then I have to change the links to refer to the newly copied files within each folder. I keep getting "Runtime error '1004' Method 'ChangeLink' of object '_Workbook' failed" It doesn't seem to matter whether I ... 16 Feb 2006 23:15