Replies

That will give you hours and decimal part of an hour, not hours and minutes. This is fine if it is what he wants.

Try using a custom format of:

[h]:mm

The brakets must be entered into the format. This tells Excel to fromat the time value as an elapsed time (can be more than 24 hours) not a time of day.

In the VBA Editor, in the project explorer, right click on the workbook and select view code from the pop up menu. At the top of the VB editor window in the left drop down list where is should say “General,” drop the list down and select “Workbook.” If the right drop down list does not now say “Open” then drop the list down and select “Open.” The edit area should now contain:

Private Sub Workbook_Open()

End Sub

Put your Auto_Open code between those two lines. It should open when the workbook is opened.

When were you trying? The entire MS network has been down/inaccessable for most of two days this week (I’m not sure how you tell since it is usually so slow that it is hard to tell if it is working or not ). The first time this week they were down because a technician made a bad change in one of their network routers. The second time was because of a hacker Denial Of Service attack flooding their DNS servers with invalid requests. It hasn’t been a good week for them.

Overhead, and which to use would depend on exactly what you are doing. If you do not have a lot of formatting that is message dependant, then using a single form is probably what I would do. If each massage requires a lot of different formatting that would have to be done with code for a single form, but could be done at design time with multiple forms, then I would probably use multiple.

The only Icon/image that I know of that you can put into a msgbox is the standard question mark, exclamation point, etc that you control with the msgbox parameters. I don’t think you can put your own icon/image in a msgbox. Yes, I would use a user form to do this.

I had a similar requirement in an application that I wrote, and unfortunately I did not find an easy solution. What I ended up doing was to have the application set up its own Menu and tool bars and replace the Print buttons with buttons that execute my own VBA code. You could also just replace the buttons on the standard menus and tool bars it this is the only change you need to make. Then the VBA code displays a print setup form if necessary, makes the format changes, uses the .Printout method to print he necessary ranges, and then changes the formats back. The really complex part comes in managing when your menu and tool bar changes get made and when you change them back to the standard Excel commands. There are many events that have to do this, and Excel is not very consistent about when some of these events fire. Good luck.

There are several approaches that you can take to accomplish this, and Stephan has given you one. However, it does have a possible problem of having the macro run when you don’t want it to.

Another method would be to create another workbook that contains an Auto_Open macro. You can then schedule Excel to run with this workbook as a parameter on the command line. The Auto_Open macro would then open workbook 2 that contains the data and the macro that you want to run, and it would then run the macro. This way, when you just open workbook 2, the macro would not run.

Nenad: You will need OCR (Optical Character Recognition) software for the scanner. This software attempts to turn the scanned image into ASCII text. The success of this is dependant on a number of things like the resolution of the scanner, the quality of the document being scanned, the size and font of the text in the document. Under perfect conditions, you are likely to get a 98% correct scan. It has been a few years since I did any of this, so I don’t know what software is available today. I would guess that there is a fairly good chance that the software came on the disk/CD that came with the scanner, but you may get a better conversion from software you pay separately for.

Most likely there is something in the cells that makes Excel think that the values are text not numbers. It could be something like spaces before the first digit or some other non-display character. When you retype the number, you are removing whatever is causing the problem. How did the data in the cells get there in the first place? Was the data imported from a file, copied and pasted from somewhere like a web page, or some other source that might have included some non numeric characters? This could also cause things to not sort correctly. Another possibility is that the cells are formatted as text.

The maximum number of rows for Excel 2000 is 32,767. For Excel 95 and earlier it is 16,383. I’m not sure which it is for Excel 97, but it is one of those two.

Eddie: I think that should always happen when you reply to a message that contains an attachment since it is assumed that the person that sent the attachment already has it. It should not happen when you forward a message, and if it is I do not know what might be causing it.

Keely: The following VBA Subroutine will add one to cell C3 when executed:

Public Sub AddOne()
    Range("C3").Value = Range("C3") + 1
End Sub

In the cases you gave, it has the same affect as if you put a zero in front of the plus or minus sign. In the case of the plus sign, 0+B11 is the same as B11 and having the plus sign there does nothing. In the case of the minus sign, 0-D3 changes the sign of the value in cell D3 before it is used. If D3 contains a 3, then the value used in the calculation is -3. If D3 contains -3, then the value used in the calculation is +3.

Right click on your desktop and select “Properties” from the pop up menu. In the resulting “Display Properties” dialog box click on the tab at the top labeled “Plus!”. In that display check to see if your “Recycle Bin (empty)” icon has been changed to be the same as the “(full)” icon. If so, then change it back to the “(empty)” icon.

Ricky: There are a number of things that you can do, depending on how you are using this “spreadsheet”. The easiest would be to insert the date manually into the cell by selecting the cell and pressing Ctrl/; (hold the Ctrl key down and press the semi-colon). The only other choice that I know of without writing some VBA code is to use the forula you have already tried, but then manually copy the cell and do a Paste/Special/Values to replace the formula with the value. However, that takes more actions than just entering the date with Ctrl/;.

If you want to automate this, then you will need some VBA code. If you are using the “spreadsheet” as a template, then you can attach this code to the NewWorkbook event, and have the code place the date into the appropriate cell. If you are simply opening the spreadsheet, then you would attach the VBA code to the Workbookopen event. The code would have to check the cell where you want the date to see if it already contains a date, and if it does not then insert the date.