Summary: I need to put a time stamp in a excel workbook, i tried Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+; which does give a timestamp, but ...
Summary: Writing a Word macro which edits a Winamp play list into a listing for a CD label. I would like the macro to know when it reaches the end of the list...
Summary: This should help you see the light at the end of your carpel tunnel: Paste your links as HTML into a spreadsheet, select them and run this code. It sh...
Summary: Hi Boris, your e-mail is most likely time stamped at the time it was received at your ISP's server not when you download it. Check it out by sending ...
Summary: I'm getting dotted lines at the end of every page in Word 2000. I can remove them, but they pop back right away (and sometimes I can't remove them). T...
Summary: Currency (assumes there's ALWAYS a space between currency code and value): =LEFT(B2,SEARCH(" ",B2)-1) Value (assumes you will ALWAYS have a comma at t...
Summary: In my (PC) 2007 version, Draft Mode honors the margins I set up. It word wraps at the end of a line. If you have 2007, try on the View tab, unhide rul...
Summary: Thanks Derby. Now I can feel myself at the end of a tunnel. 1 - Yes 2 - Yes 2a- This is what keep me thinking. I feel isn't it can be set condition th...
Summary: Hi, I wrote the UDF because it is likely to be an easier option to manage when changes are made to a database in the future. Whilst I recognized that ...
Summary: Thanks Humar. Your suggestion works well. Teh macro now starts teh VBA script. However, A new problem has arisen, which I had not forseen. The temp...
Summary: I am trying to create a time card that will allow me to look at my hours and determine at the end of the week how many hours I have to work to get to ...
Summary: I have a table of employee details i.e. Name Surname Employee ID In addition to values such as: Site ID and a week ending date. All contained on one ...
Summary: I think this more of a programming problem than a spreadsheet problem. What you are appearring to do is to have the most recent appearance of a digit...
Summary: Thanks derbydad. FYI: I couldn't get back logged in as "russells" and had to re-register. It must be pretty obvious by now that my VBA knowledge is la...
Summary: How do you calculate time if the time period is typed in one cell. example: Cell A1: 0500 - 1530 Cell B1: 1200 - 1830 Cell C1: 1300 - 2230 My main go...
Summary: You use the variable myfile to request the filename from the user. Therefore, you need to use that variable any time you want to refer to that file. T...
Summary: Hi, I know you have been working at this for some time, so you likely have looked at these issues, but it might help to know the following: 1. In the ...
Summary: I'm using Outlook 2002 in WinXP and I have set it up to download new mail from the POP3 server that hosts my Web site. Since my ISP (Verizon) won't r...
Summary: Thanks for offering to help. I think our needs are a lot simpler than yours. What we're looking for is Date / Time in / Time out / meal breaks (a dedu...
Summary: Are you hitting the enter key at the end of every line? If so, every line becomes a new paragraph and each paragraph starts with a new sentence. So Wo...
Summary: Don't know whether I can explain this problem. I have someone who is looking to make a template for some forms he has to fill out (about 13 pages wort...
Summary: I know how to move focus around in Access Forms using SetFocus.... but how can I force the cursor to move to the end of a text box when it gets focus ...
Summary: Two things to try. locate the shortcut to Outlook and right click on it. Go to properties. In the Target catagory you will see the path to Outlook. At...
Summary: I am attempting to perform a data analysis using data collected through a parallel port. I have a macro written that does not do what it is supposed...
Summary: Found this in OE Help; To create a group of contacts You can create a single group name (or alias) to use when sending a message to several contacts a...