Automatically add calendar events?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Auto sorting? Auto lock? --____QVNHWPNZZYRFJGJPVEVF____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Wed, 11 Mar 2008 08:26:31 -0500" SSBoYXZlIGEgd29ya3NoZWV0IGluIHdoaWNoIEkgZW50ZXIgZGF0YSB1bmRlciA4IHRpdGxlZCBj b2x1bW5zLiBBZnRlciBlbnRlcmluZyBpbmZvIG9uIHRoZSA4dGggYW5kIGZpbmFsIGNvbHVtbiwg SSB3b3VsZCBsaWtlIGZvciBleGNlbCB0byBzb3J0IGJ5IGNvbHVtbiAxLCB3aGljaCBpcyB0aGUg ZGF0ZSwgYW5kIGFsc28gbG9jayB0aGUgcm93LCBzYXkgcm93IDI0LCBwcmV2ZW50aW5nIG1pc3Rh a2VzIG9uIHByZXZpb3VzbHkgZW50ZXJlZCB0cmFuc2FjdGlvbnMuIElmIGFueW9uZSBrbm93cyBo b3cgdG8gaGVscCwgSSB3b3VsZCBkZWZpbml0ZWx5IGFwcHJlY2lhdGUgaXQuDQoNCkRhdmlk --____QVNHWPNZZYRFJGJPVEVF____ Content-Type: multipart/related; boundary="____UTWYPPFWWFEFDBBPDCPN____" --____UTWYPPFWWFEFDBBPDCPN____ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Wed, 11 Mar 2008 08:26:31 -0500" PEhUTUw+PEhFQUQ+DQo8TUVUQSBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZSBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPE1FVEEgY29udGVudD0iTVNIVE1MIDYuMDAuMjkwMC4z MjY4IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiA0cHggNHB4 IDFweDsgRk9OVDogMTBwdCBUYWhvbWEiPg0KPERJVj5JIGhhdmUgYSB3b3Jrc2hlZXQgaW4gd2hp Y2ggSSBlbnRlciBkYXRhIHVuZGVyIDggdGl0bGVkIGNvbHVtbnMuIEFmdGVyIGVudGVyaW5nIGlu Zm8gb24gdGhlIDh0aCBhbmQgZmluYWwgY29sdW1uLCBJIHdvdWxkIGxpa2UgZm9yIGV4Y2VsIHRv IHNvcnQgYnkgY29sdW1uIDEsIHdoaWNoIGlzIHRoZSBkYXRlLCBhbmQgYWxzbyBsb2NrIHRoZSBy b3csIHNheSByb3cgMjQsIHByZXZlbnRpbmcgbWlzdGFrZXMgb24gcHJldmlvdXNseSBlbnRlcmVk IHRyYW5zYWN0aW9ucy4gSWYgYW55b25lIGtub3dzIGhvdyB0byBoZWxwLCBJIHdvdWxkIGRlZmlu aXRlbHkgYXBwcmVjaWF0ZSBpdC48L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPkRhdmlk PC9ESVY+PC9CT0RZPjwvSFRNTD4= --____UTWYPPFWWFEFDBBPDCPN____-- --____QVNHWPNZZYRFJGJPVEVF____-- Tag: Automatically add calendar events? Tag: 138844
  - 2
    - Unexpained Shortcut to Personal.xls I have Office 2003's Excel set up on my desktop and my laptop under XP Home. They both work as expected. Personal.xls is in Program Files\Microsoft Office\OFFICE11\XLSTART on both machines. However, on the Desktop alone there is a shortcut to it in Documents and Settings\Main\Application Data\Microsoft\Excel\XLSTART. I delete the latter and open Excel and all the macros in Personal.xls that are tied to buttons and menu items work just fine without the shortcut. But when I close Excel, the shortcut reappears in Documents and Settings\Main\Application Data\Microsoft\Excel\XLSTART. This does not happen on the laptop. There must be something in the way I have the two Excels set up. The laptop has my name as the user name and the desktop has Main as the user name. This is the only difference I am aware of. This does not cause any problems that I can see but I am curious about why it should happen on one machine and not the other. I will appreciate any guidance on this riddle. Thank you. Tag: Automatically add calendar events? Tag: 138837
  - 3
    - Please help: opening a datastream comma delimited Hello Anyone help? I'm trying to open a data stream in excel from my own remote server which uses comma delimitation and I'm trying to get Excel to open as such, instead of sticking all the data in one column. Someone suggested the code below might work from but on 'startrow' it throws up a 'compile error' that 'named argument is not found'. Anyone have an idea how to do it? I'm no expert. Workbooks.Open Filename:="http://x.x.x.x:8085/ppui/resultscsv?CUSTOMER=BOOKINGID=8165806", Origin:=437, Startrow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True Tag: Automatically add calendar events? Tag: 138828
  - 4
    - Adding like occurences I can't figure this one out and need help. Sheet1 has names in col 1 and values in col 2 - I want to add totals together for everytime a certain name is found in col 1 in the sheet 2. (Name is listed multiple times on sheet 1) This is easy but I can't remember how to do it! Thanks for any help provided. Annette Tag: Automatically add calendar events? Tag: 138823
  - 5
    - Drop-down lists --____APTVTIKANCHSADEVXJRW____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Wed, 11 Mar 2008 04:16:00 -0500" SXMgdGhlcmUgYW55d2F5IHBvc3NpYmxlIHRvIGNyZWF0ZSBhIERyb3AtZG93biBsaXN0IHRoYXQg aW5jbHVkZXMgdGhlIGRhdGVzIG9mIG9ubHkgdGhlIGN1cnJlbnQgbW9udGg/IElmIGl0J3MgTWFy Y2ggSSB3b3VsZCBsaWtlIGNvbHVtbiBBIHRvIG9ubHkgaGF2ZSBNYXJjaCAxc3QgdGhyb3VnaCB0 aGUgMzFzdCB0byBiZSBwb3NzaWJsZSBlbnRyaWVzLiBXaGVuIGl0IGJlY29tZXMgQXByaWwsIHRo ZW4gQXByaWwgZGF0ZXMgYXJlIG9ubHkgb25lcyBhbGxvd2VkLCBhbmQgc28gb24uIElmIHNvbWVv bmUgY291bGQgaGVscCB0aGF0IHdvdWxkIGJlIGdyZWF0IQ0KDQpEYXZpZA== --____APTVTIKANCHSADEVXJRW____ Content-Type: multipart/related; boundary="____KWGZCTCLPZSFANYZDVPO____" --____KWGZCTCLPZSFANYZDVPO____ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Wed, 11 Mar 2008 04:16:00 -0500" PEhUTUw+PEhFQUQ+DQo8TUVUQSBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZSBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPE1FVEEgY29udGVudD0iTVNIVE1MIDYuMDAuMjkwMC4z MjY4IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiA0cHggNHB4 IDFweDsgRk9OVDogMTBwdCBUYWhvbWEiPg0KPERJVj5JcyB0aGVyZSBhbnl3YXkgcG9zc2libGUg dG8gY3JlYXRlIGEgRHJvcC1kb3duIGxpc3QgdGhhdCBpbmNsdWRlcyB0aGUgZGF0ZXMgb2Ygb25s eSB0aGUgY3VycmVudCBtb250aD8gSWYgaXQncyBNYXJjaCBJIHdvdWxkIGxpa2UgY29sdW1uIEEg dG8gb25seSBoYXZlIE1hcmNoIDFzdCB0aHJvdWdoIHRoZSAzMXN0IHRvIGJlIHBvc3NpYmxlIGVu dHJpZXMuIFdoZW4gaXQgYmVjb21lcyBBcHJpbCwgdGhlbiBBcHJpbCBkYXRlcyBhcmUgb25seSBv bmVzIGFsbG93ZWQsIGFuZCBzbyBvbi4mbmJzcDtJZiBzb21lb25lIGNvdWxkIGhlbHAgdGhhdCB3 b3VsZCBiZSBncmVhdCE8L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPkRhdmlkPC9ESVY+ PC9CT0RZPjwvSFRNTD4= --____KWGZCTCLPZSFANYZDVPO____-- --____APTVTIKANCHSADEVXJRW____-- Tag: Automatically add calendar events? Tag: 138821
  - 6
    - Recipies of South INDIA Do you want to know to how to make mouthwatering,spicy foods? If you want to know how to make delicious South Indian foods please visit http://recipesoftamilnadu.blogspot.com/ Tag: Automatically add calendar events? Tag: 138820
  - 7
    - time line in chart Hi How do I put a vertical line in a chart in excel at a given point? i.e. timeline Thanks Jon Tag: Automatically add calendar events? Tag: 138817
  - 8
    - Pick several numbers from a list to get as near as possible to required total I have a list of several hundred policies each with a different value. Occasionally I have a request to 'sell off' policies to a certain value. At the moment I manually select policies from the list till I get 'close enough' to the total. Is there a way of automating this and getting the closest result possible? To put numbers to my problem above, suppose I have the following 9 policies 1 $11,234.67 2 $604.50 3 $7,632.00 4 $5,638.76 5 $16,345.98 6 $23,678.43 7 $15,678.44 8 $1,007.17 9 $53,713.97 I get a request to sell of $54,500 worth, at a glance I would probably select policies 8 & 9 (totaling $54,721.14), where as infact policies 3, 4, 5, 6 & 8 would be a better choice as they total $54,302.54 All help would be much appreciated Gerry Tag: Automatically add calendar events? Tag: 138815
  - 9
    - Excel 2007 - Conditional Formatting copy/paste errors I find that if I create a conditional format at one cell and then copy that to a multitude of others, the variable references within the conditional format will not adjust accordingly. For example: At cell A1, I have the conditional format of "=IF(A1>0,1,0)". If I copy this to cell B2:B3 (in one stroke), I will find both cell B2 and B3 to have the same formula "=IF(B2>0,1,0)". This of course is fine for cell B2, but it is not fine for cell B3. I would expect cell B3 to reference itself; not cell B2. Another problem is that if the receiving cells should have a conditional format previously in place, the copy from A1 to B2:B3 will append to the preexisting conditional format as opposed to overwriting them. The only circumvention I have for this bug is to clear any possible conditional format before I paste to the receiving cells, B2:B3. So, how do I resolve this apparent bug in Excel? btw, this bug is not present in Excel 2003. Thanks, Bob. Tag: Automatically add calendar events? Tag: 138813
  - 10
    - match and index function - getting it to keep its original reference I am using the match and index function to pull in data from a separate worksheet. I am using Column A as the reference cell, whereas my formula lies in Column F. The formula pulls in the data fine. The problem is, when I sort the data set, the match index function maintains the original reference cell and does NOT refer to the same row. So, for example, if my formula references A3, the formula continues to use A3 after I sort the cell (as if I had used an absolute reference). Does anyone know how to fix this? How can I pull in data using matchindex (or vlookup), but also be able to sort the rows without messing the formula up? Is there a way to use a list or named ranges to accomplish this? The actual formula I am using (in case it helps) is: =IF(ISNA(INDEX(CMS2!I:I,MATCH('CPT Summary for CMS Comp'!A27,CMS2! A:A,FALSE))),0,INDEX(CMS2!I:I,MATCH('CPT Summary for CMS Comp'! A27,CMS2!A:A,FALSE))) Thanks for any suggestions. Tag: Automatically add calendar events? Tag: 138810
  - 11
    - Show leading zeros (eg: 000123) When I import a file that originally had numbers such as "000123" in excel, the number only shows 123. Is there a way for me to get the cell to show 000123? Thanks Tag: Automatically add calendar events? Tag: 138809
  - 12
    - adding a leading 00 to some loan numbers I've got several thousand loan numbers which need to be updated to a ten-digit format by adding a leading 00. That's easy enough to do, HOWEVER, some of them have already been updated with the leading 00. What formula can I use to add 00 only to those which have not already been updated? Thanks. -- alan Tag: Automatically add calendar events? Tag: 138799
  - 13
    - Counta not calculating correctly??? Count anyone shed some light on this issue. I am using the statement n = WorksheetFunction.CountA(Cells(i, 13), Cells(i, 17), Cells(i, 22)) I am trying to get a value for how many of the 3 cells have data in them. While watching my n count I am seeing it reading 2 when there is clearly only data in one of the cells. Any idea why this would be reading incorrectly? Thanks for any help -- KWB Tag: Automatically add calendar events? Tag: 138779
  - 14
    - e-mail addresses Hi Everyone I am having a problem with e-mail address in excel spreadhseet. Some of them go in, in black the same as the rest of the spreadsheet, but others show up in BLUE and then they are clickable. I would just like them all in black. What should I do, or what an I doing wrong? Thanks Donna Tag: Automatically add calendar events? Tag: 138771
  - 15
    - how to create an excel template I am having problems trying to create an excel template. I took a xlt file. and put it in the dir C:\Program Files\Microsoft Office\Templates\1033 However I do not see it ever showing up in the file>new>on my computer is there something special you have to do? thanks Tag: Automatically add calendar events? Tag: 138761
  - 16
    - How to add SAMPLE ONLY overlay? Hi - how do I add 'SAMPLE ONLY' diagonally across a tab and have it somewhat transparent? I've tried pasting in a jpg of SAMPLE created using Viso, but that background of the pic is not tranparent. Pete Tag: Automatically add calendar events? Tag: 138758
  - 17
    - Selecting a folder to save xml to... I have the following code that works fine in Excel 2003 and I am looking for something similar that will produce the same result but for Excel 2000 can anyone help? If xmlfolder = "" Then MsgBox "Select folder for the XML file", vbCritical With Application.FileDialog(msoFileDialogFolderPicker) .Title = "SELECT FOLDER" .AllowMultiSelect = False ' Folder selected If .Show = -1 Then xmlfolder = .SelectedItems.Item(1) & "\" End If Regards Jamie Tag: Automatically add calendar events? Tag: 138755
  - 18
    - Autofilter - No. of Rows Does anyone know of any way to increase the number of rows displayed in Autofilter, becauase when working on large ranges it doesn't display all values. Any help greatly appreciated..... Tag: Automatically add calendar events? Tag: 138754
  - 19
    - Startup Hello My Excel VBA is sometimes used by other people, and they ara "abusing" my codes by using toolbar commands. I want to make Excel VBA and to hide / disable all toolbars and any other Excel command. I want that only my buttons can be used. Beforehand thanking for any help,7 Sb. Tag: Automatically add calendar events? Tag: 138753
  - 20
    - flip columns to rows Is there any way to 'flip' a worksheet with one command, so that columns become rows (or rows become columns)? Tag: Automatically add calendar events? Tag: 138748
  - 21
    - Outsourcing Data Entry 100% guaranteed or your money back Data Entry Outsourcing Services ensures high quality, result oriented in time. We promise to deliver excellent output at low turn around times and cost-effective rates. Our dedicated team of highly experienced professionals to provide you high quality outsourcing services. Do visit us at http://www.dataentryoutsourcing.co.uk/dataentry_services.php, to know more about our Data Entry Outsourcing Services and avail our services at affordable rates. Data Entry Outsourcing provides data entry services like numeric data entry, textual data entry, image data entry, data format, data conversion and also online data entry, offline data entry with 99.98% accuracy and time bound. Data Entry Services also provides form data entry, data capture, HTML/ SGML coding, image scanning, file conversion with low cost, high quality, time bound and high data security. By taking advantage of Data Entry Outsourcings domain knowledge, quality processes, high-tech infrastructure, and global delivery options, clients are able to perform better while allowing them to concentrate on their core competencies. Based in U.K., Data Entry Outsourcing operates from offshore multiple production centers in India. Contact us for more information about Data Entry Services. E-mail Us: info@dataentryoutsourcing.co.uk Phone (India): +91-794-000 3000 Fax : +91-794-000 3002. Tag: Automatically add calendar events? Tag: 138745
  - 22
    - Remove Final Character from Cell. Hi All, I am trying to remove the final character from a cell with a find and replace. the cell contents are like the following example. 07APR07A needing to be 07APR07 But other cells in the list are already in the format of 07-Apr-07 07APR07* I have managed to remove the * by using the tide ~ character. So I don't know if there is a similar character to remove the last character only. But am stuck with the last character. Can someone please help. Tag: Automatically add calendar events? Tag: 138741
  - 23
    - runtime error '429' activex component can't create object We recently moved to "visual studio 2008" . Our addin workd find on our development machine which has Excel 2003 and Excel 2007. When we create the installation package and install onto a machine with only Excel 2003 we get the "runtime error '429' activex component can't create object". Any ideas please. Thanks in advance Tag: Automatically add calendar events? Tag: 138738
  - 24
    - Excel crashed with ntdll.dll when opening a file Dears, My Excel crashed with ntdll.dll when opening a file Error signature AppName: excel.exe AppVer: 10.0.6834.0 ModName: ntdll.dll ModVer: 5.1.2600.2180 Offset: 00010f29 I am using Office XP with SP3, Windows XP with SP2. Thanks B. G. Tag: Automatically add calendar events? Tag: 138736
  - 25
    - Putting a "period" at the end of every cell's-worth of text Hi. I have a large number of cells in a column, each of which contains text. Some cells of text end in a period, some do not. Is it possible to write a function that would add a period to the end of each textbox? I am not worried about corner cases, i.e., where the text ends with "M.D." or suchlike. Thanks for any help - Tag: Automatically add calendar events? Tag: 138727
- Next
  - 1
    - Time passed sinec date in column A I am trying to greate a document that will tell me when someone needs to renew thier training. I have 1, 2, 3, & 4 yearly training programs. I want to have a system where I can set conditional formating to goy amber when it has been 10 months since the date and then Red when over a year> I have a date on column A. In column B I want to know how many months have passed since that date. I am sure the solution is easy, but I can't work it out!! Many thanks Steve Tag: Automatically add calendar events? Tag: 138726
  - 2
    - I am interested in knowing some of your favorite Excel Add-ins Hello - I have been too cheap to buy any excel add-ins or plug-ins, and then recently I downloaded one (i.e., the PUP v6 toolbar), and realized that it was worth much more than the $40 price tag. I would be interested to hear some of your favorite add-ins (either free or purchased) and why you find them to be valuable. It would also be helpful to have the link to where they can be found. Thanks! - M Tag: Automatically add calendar events? Tag: 138725
  - 3
    - Data grouping and averaging in excel 2003 I am looking into purchasing a data logger that will collect voltage, amperage with a time scale. Below is a sample of the data and a summary to be generated above the data. I have some problems with how I can have a msexcel spreadsheet automatically calculate averages and total times for each zone. I would like a summary for many separate zones with a dozen or so sessions that have recording to last from 10 to 100 seconds within each session and automatically disregard calculating any values in column C that are <30 & all rows in column B that have been disregarded in column C. Averaging for volts and amps will include all readings within each zone. To calculate time, I would like to calculate the difference between when the amps go above 30 & the time when the amps drop below 30 + the time one row down. Formulas In A2 =(A11-A9)+(A15-A13)+(A20-A15) In B2 =AVERAGE(B9:B10,B13:B15,B18:B19) In C2 =AVERAGE(C9:C10,C13:C15,C18:C19) In A3 =(A24-A22)+(A29-A26) In B3 =AVERAGE(B22:B23,B26:B28) In C3 =AVERAGE(C22:C23,C26:C28) A B C D 1 total time avg volts avg amps total zone 2 00:00:54 25.3 122 b 3 00:00:30 25.0 125 f 4 5 6 7 8 time volts amps zone 9 13:30:12 24.9 131 b 10 13:30:18 25.3 124 b 11 13:30:24 39.4 12 b 12 13:30:30 38.4 9 b 13 13:30:36 26.3 130 b 14 13:30:42 24.9 114 b 15 13:30:48 25.3 125 b 16 13:30:54 39.4 2 b 17 13:31:00 38.4 8 b 18 13:31:06 25.2 111 b 19 13:31:12 25.1 117 b 20 13:31:18 39.4 3 b 21 13:31:24 38.4 13 b 22 13:31:30 25.1 125 f 23 13:31:36 25 131 f 24 13:31:42 38.4 7 f 25 13:31:48 37.6 11 f 26 13:31:54 25 124 f 27 13:32:00 24.9 130 f 28 13:32:06 24.8 114 f 29 13:32:12 37.6 11 f Can anyone help me with this? And an I on the right track? Can this be accomplished without VBA? (as I have no success with it in the past) Thank you for your consideration. Tag: Automatically add calendar events? Tag: 138705
  - 4
    - Data grouping and averaging questions in excel 2003 I am looking into purchasing a data logger that will collect voltage, amperage with a time scale.Below is a sample of the data and a summary to be generated above the data. I have some problems with how I can have a msexcel spreadsheet automatically calculate averages and total times for each zone. I would like a summary for many separate zones with a dozen or so sessions that have recording to last from 10 to 100 seconds within each session. I would like to automatically disregard calculating any values in column C that are <30 & all rows in column B that have been disregarded in column C. Averaging for volts and amps will include all readings within each zone. To calculate time, I would like to calculate the difference between when the amps go above 30 & the time when the amps drop below 30 + the time one row down. Formulas In A2 =(A11-A9)+(A15-A13)+(A20-A15) In B2 =AVERAGE(B9:B10,B13:B15,B18:B19) In C2 =AVERAGE(C9:C10,C13:C15,C18:C19) In A3 =(A24-A22)+(A29-A26) In B3 =AVERAGE(B22:B23,B26:B28) In C3 =AVERAGE(C22:C23,C26:C28) A B C D 1 total time avg volts avg amps total zone 2 00:00:54 25.3 122 b 3 00:00:30 25.0 125 f 4 5 6 7 8 time volts amps zone 9 13:30:12 24.9 131 b 10 13:30:18 25.3 124 b 11 13:30:24 39.4 12 b 12 13:30:30 38.4 9 b 13 13:30:36 26.3 130 b 14 13:30:42 24.9 114 b 15 13:30:48 25.3 125 b 16 13:30:54 39.4 2 b 17 13:31:00 38.4 8 b 18 13:31:06 25.2 111 b 19 13:31:12 25.1 117 b 20 13:31:18 39.4 3 b 21 13:31:24 38.4 13 b 22 13:31:30 25.1 125 f 23 13:31:36 25 131 f 24 13:31:42 38.4 7 f 25 13:31:48 37.6 11 f 26 13:31:54 25 124 f 27 13:32:00 24.9 130 f 28 13:32:06 24.8 114 f 29 13:32:12 37.6 11 f Can anyone help me with this? And an I on the right track? Can this be accomplished without VBA? (as I have no success with it in the past) Thank you for your consideration. Tag: Automatically add calendar events? Tag: 138703
  - 5
    - How to add the date after the "A1" Hi, I type "The information gathered as of March 9, 2008" on cell "A1" Is there a way to make a date default like "The information gathered as of " & Date (default). Your help would be much apprecated. Tag: Automatically add calendar events? Tag: 138697
  - 6
    - Compatibility Question I have created a file in Excel 2003, and saved as "Excel 97-Excel2003 &5.0/95 Workbook" and I am running XP. The file utilizes several macros, VLOOKUP and COUNTIF commands. My question is if this file is distributed throughout the general public, what do you believe could be some unforeseen compatibility issues I am not aware of as it will obviously be opened on several versions of Operating Systems and versions of Excel? Do I have a 50% chance of success that it will be compatible? What would be your guess at the percentage of success? What are my options to make it more successful throughout more OS systems and Excel versions? Will some type of compatibility pack be the answer? Thanks for the anticipated help. JR Tag: Automatically add calendar events? Tag: 138687
  - 7
    - RIGHT & UPPER Function help I am working in Excel 2002. The postal address is in cell A1 with the postcode. I am looking to take the postcode out of the cell and put in new cell and turn into CAPITAL letters. 1 The High Street London ln22 4tb I am struggling with the function for this. I am at =RIGHT(A1,8) which takes the postcode from the end of the address and enters ino cell A2 but I thought i may have been able to add the UPPER to the end of the function but this does not work. I can do this as =UPPER(A2) in cell A3 but was hoping to undertake the augument in the same cell. Also can I adapt the augument to include where I only have 6 characters ie LN24tb? Many thanks Roger Tag: Automatically add calendar events? Tag: 138685
  - 8
    - Excel 2000 opens then immediately closes Running under Vista Home Premium 64. When I open a worksheet/workbook it loads, appears on the screen then immediately closes. Have carried out 'repair', prefer not to un-instal re-install. Help! Tag: Automatically add calendar events? Tag: 138684
  - 9
    - dividing one time by another If I use =B1/C1 to divide one time by another (eg. 76:12 by 43:23, where the times are minutes:seconds) I get weird answers. If I reformat the cells with [m]:ss, the formula doesn't work at all. Any suggestions? Adrian Tag: Automatically add calendar events? Tag: 138680
  - 10
    - Open Excel File in a new Window Hi, I am not sure if this is an Excel problem or it is in Office in General. If I open two MS Word Files, they open in two separate windows. However if I open two Excel files - they open in the same Window. The benefit of having two separate windows is that they can be placed side-by-side esp. if you have multiple monitors. Is this possible in Excel?? I hope my description is clear. If not let me know and I would try to explain again. Regards, O.O. Tag: Automatically add calendar events? Tag: 138664
  - 11
    - Match & Index function - Cell format problem that is keeping it from Hello - I am trying to use the Match and index functions together. Typically, I have been able to match and pull in the data without a problem. But now that I am using a text file that I export into excel, I am running into problems. Basically, the formula won't work (even though I have tried trimming the data, changing all columns to text, general, and number. The only way that the formula works is when I copy and paste the actual reference cell into the reference array from the range that I am seeking to pull in the data. So for example, my formula reads: =INDEX(Sheet2!B:B,MATCH(Sheet1! A419,Sheet2!A:A,FALSE)), but the only way that I get the data from Sheet2 column B is by physically pasting Sheet1!A419 into column A in in Sheet 2. Then and only then will the values from Column B in sheet2 appear in Sheet 1-- as the formula is intended to do. Is anyone familiar with this problem? Does the function typically work better when the sheets are formatted as general, versus number, versus text? Thanks for any suggestions. (Also, another problem I am experiencing with the files----and it may be related-----is that the formulas will not work altogether. That is, any formula that I punch into the cell does not produce a value, but instead the cell shows the formula when I press enter. However, this I am usually able to fix by formatting the book as general and then retyping the formula in the cells). Tag: Automatically add calendar events? Tag: 138657
  - 12
    - Formula Can anyone help please with this formula. =COUNTIF(B208:AE208,"H") This works fine to count the number of H's in a row. What I need is to also count HD as .5 in the same row and add it to the final total. For instance in the first row H H HD H = 3.5. I may at a later date also need to add to it again with a S also to count 1. Can anyone help with the formula please. Maybe COUNTIF isn't the correct one to use. Thanks. Bryan. Tag: Automatically add calendar events? Tag: 138653
  - 13
    - Something New Excel 2003 SP2. I've been revising a workbook and came across an Excel quirk that's new to me. I haven't read about anything similar in the newsgroups. The workbook in question usually has all worksheets protected and the workbook protected, but I've unprotected the workbook and all worksheets and unhidden all but one worksheet. Some of the worksheets have embedded spaces in their names. There are no worksheet events, but there are workbook Open, Activate, Deactivate and BeforeClose events. There's also one udf, named HasFormula, that takes a Range object as its argument and returns TRUE/FALSE if the first cell in that range has a formula. I only use this udf in conditional formatting formulas. I'm editing formulas in one of the worksheets that's usually hidden. Call it Sheet C. The formulas were something like ='Sheet B'!X99 and I want to change them to =IF('Sheet B'!X99<>"",'Sheet B'!X99,'Sheet A'!C123) I edit the formula in a cell in Sheet C, inserting the 'IF(' at the beginning, copying the original cell reference in the formula bar, appending '<>"",', pasting the cell reference, and appending a comma. Then I press [F2] to change to Enter mode, repeatedly press [Ctrl]+ [PgUp] to move to 'Sheet A', move to cell C123 in that worksheet (now in Point mode), type a right parenthesis and then press [Enter]. Here's the quirk: Excel tries to enter the edited formula into 'Sheet A'!C123 rather than into the cell in Sheet C that I began editing. Fortunately, 'Sheet A'!C123 has a validation rule that rejects the formula. I should also mention that Sheet A has separate frozen panes, and C123 is in the lower, unfrozen pane. Has anyone else had Excel do this? I can work around it, so I'm not looking for an immediate fix, but this is definitely annoying. If there's an easy fix, I'd be grateful for any pointers. Tag: Automatically add calendar events? Tag: 138648
  - 14
    - returning more columns with vlookup? Hi all by default vlookup returns 1 column. Is there a way to return more than 1 (not necessarily adjacent) columns? example instead of =VLOOKUP(38, A2:L10, 3, FALSE) using something like =VLOOKUP(38, A2:L10, (3,7,9), FALSE) that would return cells in columns 3, 7 and 9 ? Thanks! Tag: Automatically add calendar events? Tag: 138627
  - 15
    - Deleting pictures Hi I have a series of pictures in a spreadsheet that I am wanting to delete but am unable to find another way than individually selecting each one and manually deleting. I DO NOT want to hold CTRL and select as there are over 600 pictures to delete. Any ideas? any help is appreciated. Andrew Tag: Automatically add calendar events? Tag: 138622
  - 16
    - Formula - If then else Using Excel 2002: SP2 Greetings, I have not used Excel at any depth in for several years so I am rusty with formulas, etc. I wish to set up a formula so that When column B = "NNE" column C = "N" When column B = "ENE" column C = "NE" When column B = "NNW" column C = "N" When column B = "WNW" column C = "NW" etc Basically I want to reduce 16 compass points to 8 but the groupings may be based more on preference than what logic would suggest. I have never used a VB script and don't even know how to set up one though I am an experienced programmer (HP Basic, C/C++, etc). Thanks, gtb Tag: Automatically add calendar events? Tag: 138621
  - 17
    - Sum of Colored Cells hi all, suppose i have a range of cells, and that range needs to summed depanding on the cells color. for example, i need to sum the cells colored with green in one cell, and the cells colored with red in another cell and so the blue ones. is there any way to do that? many thanks in advance. Tag: Automatically add calendar events? Tag: 138619
  - 18
    - exclude headings from sort Hi all how can I set my column headings (cells in row 1) so that they stay on top when I do sorting? Thanks! Tag: Automatically add calendar events? Tag: 138616
  - 19
    - Paste Special Default Most often if not always when I use Paste Special in Excel 2003, I want to use the Value option. The default is All. Is there any way I can change the default to Value? Thank you. Tag: Automatically add calendar events? Tag: 138612
  - 20
    - Delete Asterisk besides Numbers in a Cell Hi, I have an Excel Spreadsheet with numbers. Some of the numbers have an Asterisk besides them. E.g. 324* Is there a simple way to delete all Asterisk's in the entire spreadsheet. (There are no other Asterisk's than these unwanted ones.) If I use the Find and Replace i.e. search for * and keep the replace thing blank - it deletes the entire sheet. Any ideas? Thanks a lot. O.O. Tag: Automatically add calendar events? Tag: 138607
  - 21
    - slow to open files Hello, Excel 2007 files are very, very slow to open. I have saved my 2003 files to the 2007 format and they still open slowly. Has anyone else had this problem? Is there anything that can be done about it. I have noticed it on two different computers (both running Windows XP). Thanks................SBennett Tag: Automatically add calendar events? Tag: 138606
  - 22
    - Stopwatch in Excel I'm creating a spreadsheet for logging railway performance timings. I need a stopwatch in excel that can give a split / lap reading, preferably when the enter key is pressed. I reckon it can be done with the now() function, as this can give the needed accuracy (1/100 second) if the format hh:mm:ss.00 is used. I've not got much experience with macros etc, so I would be very grateful for any suggestions on ways to go about this. Ideally, when the split button is pressed, it will give the split time and the difference from the previous split time in a new cell, so by the end I have a list of times. I will be able to use these to calculate average speeds etc. Thanks. Tag: Automatically add calendar events? Tag: 138601
  - 23
    - Venturing into date formulas... Do not know if this is possible, but believe all is possible given the right guidance... Have a worksheet and shall we say in column C there is a date Jan 1, 2008 Now in column E I would like it to take the date from column C and show the number of days left in a 2 year period from the original input date of 1/1/08 So basically when you input 1/1/08 it would show say 730 in E and if you change the date in C to February 1, 2008 it would show 699. Is this possible????? Tag: Automatically add calendar events? Tag: 138594
  - 24
    - suggestion I have numbers in a column and an example of the numbers in one cell is 0 -000-2108-000 My problem is that I want to remove the first numbers, or hide them or sort the cell such that 2108 is in front. The bottom line is that I want to sort the column by the 2108 number and do it in an automated way rather than going 640 cells down deleting the front numbers, because I will also need them later. Any suggestions? Tag: Automatically add calendar events? Tag: 138591
  - 25
    - Cell search & reporting Hi Is there a formula that would search one cell for a month and then search a range of other cells for a date and then look below and report into the formula cell what is reported possibly in a different colour depending on what is reported. e.g. A B C D E F G 1 Date 31â?¦Month Decemberâ?¦Year 2007 2 3 MON TUE WED THU FRI SAT SUN 4 31 1 2 3 4 5 6 5 smith E E DO S E DO DO 6 jones DO N DO DO DO DO N 7 8 9 The cell in A9 would search cell B3 to find the month required, then would search cells A4 to G4 for the correct date e.g. recognise that the required date is the 3rd of january in cell D4. It would then look below in jones's line and report back S in red. Thanks in advance Jason Tag: Automatically add calendar events? Tag: 138583

Using the powershell, is there a way to add calendar events to specific
mailboxes? Our vacation time request system is a home grown web-based
application. We'd like to configure it so that once the vacation time has
been approved, the requesters Outlook calendar would then automatically be
populated with "out of office" entries for the days off they requested.

Thanks in advance!

Re: Automatically add calendar events? by Pete_UK

Pete_UK
Tue Mar 11 15:03:42 CDT 2008

I think you might have posted this to the wrong group - this is for
Excel.

Pete

On Mar 11, 7:50=A0pm, "jim" <j...@nospam.com> wrote:
> Using the powershell, is there a way to add calendar events to specific
> mailboxes? =A0Our vacation time request system is a home grown web-based
> application. =A0We'd like to configure it so that once the vacation time h=
as
> been approved, the requesters Outlook calendar would then automatically be=

> populated with "out of office" entries for the days off they requested.
>
> Thanks in advance!

Re: Automatically add calendar events? by jim

jim
Tue Mar 11 15:14:29 CDT 2008

Yah, i know. I couldn't find the "Oh crap, unsend unsend!" button.

"Pete_UK" <pashurst@auditel.net> wrote in message
news:c99c5b39-922d-4be3-982f-bb21df73ebff@h11g2000prf.googlegroups.com...
I think you might have posted this to the wrong group - this is for
Excel.

Pete

On Mar 11, 7:50 pm, "jim" <j...@nospam.com> wrote:
> Using the powershell, is there a way to add calendar events to specific
> mailboxes? Our vacation time request system is a home grown web-based
> application. We'd like to configure it so that once the vacation time has
> been approved, the requesters Outlook calendar would then automatically be
> populated with "out of office" entries for the days off they requested.
>
> Thanks in advance!