Answer Questions

• cdun2 LCS 2005 Users Staus issues

  Hi we have been installing LCS 2005 standard and have twice come up against this issue, Im sure its simple but we cant fathom it out We both login with Office communicator but it shows us as status unknown, we are both reg with the server. even though we are both online i cant msg him and we both show unknown to each other thanks Tobez wrote: Hi we have been installing LCS 2005 standard and have twice come up against this issue, Im sure its simple but we cant fathom it out We both login with Office communicator but it shows us as status unknown, we are both reg with the server. even though we are both online i cant msg him and we both ...Show All

• marthew open a workbook with events turned off

  Is there a way to open a workbook with the events disabled   In other words, I would like to open a workbook so that links can be updated, but without executing the workbook_open or workbook_activate event procedures. Hi, If you set your Macro security to medium or high then when you open the spreadsheet you will be prompted to enable or disable macros. If you select disable then your sheet will open but no code will run. Joe, I'm not sure if you can do what your asking. The code in the Workbook_Open event should fire as the workbook is being opened. A different approach might be to extract the data from the spreadsheet which you can do using ADO, there is an example on my blog. N ...Show All

• Mark The Archer Evans How to delete files ina directory with a certain pattern

  Hi, I am littel bit of knowledge on WMI and VB Scripts and i am looking to accomplish the following task on a Windows 2003 Server. - I need to scan a directory for files with a certain pattern, once i get the list, i need to delete all the files except the last iteration. Example:- Say the Dir is D:\Logs ; under that directory there will be files with the following pattern. D:\Logs\Trace.trs, D:\Logs\Trace_1.trs D:\Logs\Trace_2.trs D:\Logs\Trace_3.trs D:\Logs\Trace_4.trs D:\Logs\Trace_5.trs I want to delete all the files except [D:\Logs\Trace_5.trs]. - Srini. hey, you could use dir to browse through files in d:\Logs directory and kill if a certain condition is tru ...Show All

• SaLaMaLaYcUm Changing back color of a field based upon another field

  I am interested in changing the back color of a field based upon a second field's value. This field is contained within a continuous form. All that seems to happen currently is every occurance of that field changes its color. Each field has a different value, can this be accessed for the formating as well Unfortnuately, this does not work for my senario, because this only updates when the record first appears. This change of formatting is needed when ever I click a check box and change its value. I tried you method and yes it did change the intital value of the screen but did not allow me to update the formating on the fly. The problem with a continuos form or a datash ...Show All

• NeederOfVBHelp VBA script not accessing another workbook

  I have written a simple application for user that pulls information from another workbook. When my workbook is open, the source worksheet cannot be accessed, but when I shut my workbook down, the source workbook can be accessed. This was written using office 2003 but was saved in a 97 to 2003 format and the user is using windows xp. This is happening on the user's computer but not on my own which is on the same network. Could security on the program cause an issue due to macros Sub populate() 'total reps in team a at cell 2,9 'total reps in team b at cell 2,10 Dim repsa As Integer Dim repsb As Integer Dim monthcaps As String Dim monthproper As String Dim monthint As Integer 'monthint = Workbooks("Team Co ...Show All

• softwarejaeger Order By DateDiff() in Access Report

  Does anyone know how to realize a "ORDER BY DateDiff('d',TheDateColum,ADynamicDate) " in a Report Does not seem to work, see file on: http://www.krasinger.at/public/AccessDateDiff.zip I put the OrderBy in the Report_Open but Access seems to be confused ... Plz Help! Hi When I sort by a function / calculation, I have put the data on the report as a hidden and none printing column, then refered to the column in the order by. This usually works. This may be a way, but I had some more complex task. I have only 1 report, which I want to use for 3 completly different Statements, receiving just the same result-columns every time. So I created a Quer ...Show All

• Altis1 Help

  I am working on an Excel worksheet that has the word "TOUR" listed throughout the spreadsheet. How can I find the next "TOUR" and insert rows to make sure it is in the row I want it in       Thanks for the information, but I need to know how to look for Tour and verify that it is in a certain cell. If it is not in a certain cell, I need to insert rows until it is in the cell that I want. Hello Derek has shown you how you can find each occurrence of "TOUR". Once you have found the adress of the cell that contains "TOUR" (which the above code will do) the compare it to the adress you would like it to be and insert or ...Show All

• db-C Help with Excel VBA Code

  I am trying to format different spreadsheets. I need the data to be in the same cells for each worksheet. This data is in column A. I need to check to see if DBCS# ( ) is above Tour, and if so insert rows until Tour is in row 175, column A. The problem is that the number after DBCS# is never the same. How can I use an IF statement to make sure that the cell above Tour says DBCS# (whatever the number is) This is the If statement that I tried. If I put DBCS#46 in my IF statement, it will not work because the number after # isn't always 46. If (Range("A174:A174") = "DBCS#") And (Range("A175:A175") = "TOUR") Then GoTo label_177: Else: Do While (Range("A174:A174") <> "DBCS#") And (Range("A175:A175") <> "TOUR") Select ...Show All

• j238 NUMBER GENERATOR HELP NEEDED

  Hi, I'm looking for a letters generator from a to g. Or a numbers generator. 1 to 9. I have a scoring system for a horseshoe game I created in excel 2007 beta. I need the letters in column d3 to d13 to update once a round is completed. Which happens ok. But once a team is eliminated. I dont want a letter assined to the cell. If anyone could take a look will understand my issue. I will email you the workbook if you think you can help me out with this. I don't no vba yet but am trying to understand it. my email is trobert672@comcast.net I'm sorry mate I don't have any time at the moment to look at the file. You know what needs to be done so thats a start. Store your letters in an array and use the r ...Show All

• oaix adding text to cell with vba script

  I've done this before but I am completely blanking on what I am doing wrong with adding text or in this case a formula to a cell. The line I have and am getting an error on is Workbooks("DSL Annual Rollup").Worksheets("DSL Annual Rollup").Cells(i, 3)="January!D"&i&"February!D"&i&"March!D"&i&"April!D"&i&"May!D"&i&"June!D"&i&"July!D"&i&"August!D"&i&"September!D"&i&"October!D"&i&"November!D"&i&"December!D"&i What I mean is, you need FormulaR1C1 to set the formula. It is ok you say Range(" ...Show All

• Airmax I need to copy a linked table - as structure and data, not as linked

  Using VBA, do you know the code to copy a linked table, paste as structure and data locally. What's the source of the table data Please provide more information about exactly what you're trying to do. ...Show All

• KSK Adding a command button to the toolbar or menu bar in Excel?

  Hi I'm wondering is it possible to add a command button to the toolbar or menu bar in Excel using VBA I came across an excel file before in work that somebody had setup this way but not sure how to go about it! I basically have two buttons that I would like to have added to the toolbar or menu to make the sheet tidier and enable the user to see all the data without having to move the buttons etc. http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_buttons.jpg Any ideas folks Thanks, Scott I actually managed to get it working after many hours of trying! But much more satisfaction when u are able to do it on your own! :) So i added this code into one module... ' ...Show All

• NewbieDude VBA Excel - Using The "For each" function with a string

  Hi, I have a sentence and I need to separate each word of the string. Thanks in advance for any help. Function UsingForEach() Dim myWord, mySentence As Variant Dim Found As Boolean mySentence = "Have a nice day" For Each myWord In mySentence MsgBox myWord Next End Function Thanks man! I don't know if is possible with for each, i would try instr and " " and other substrings. Use the Split function: sub test dim myWordsArray dim mySentence as string mySentence="Hello have a nice day" myWordsArray=split(mySentence," ") End Sub and then have alook at the elements of array myWordsArray Chas ...Show All

• Siraris Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional

  This problem has been mentioned by many other users (in a different thread subject), so I wanted to start a new thread. I have tried many suggestions, but none have worked for me. My MODI has been a print option for me until just recently. It disappeared from my printers folder. I have repaired, removed, and re-installed Microsoft Office. The MODI will still not appear in the printers folder. Please Help! I can't get any of these to work!!! 1. Puts it back in my folder as an option, but when you try to print through it, it doesn't work. The printer icon down in the toolbar pops up and acts like it's working, but nothing ever gets saved/printed. 2. Doesn't work. 3. Same as #1. ...Show All

• nhaas Are there any known issues using the VBA Date function on a server running W2K3?

  Captiva's InputAccel is a capture product which has a VBA environment for coding. In my code I call the Date method and store the return value in a string for later use. The code runs on a Windows 2003 Server SP1 machine whose regional settings are English(United Kingdom). When I step through the code, the return value is in UK format e.g. 10/11/2006, but when I run the code the return value is in US format e.g. 11/10/2006. My understanding is not thorough but I believe that by steping through the code, the source is executed but when running the code, the compiled code is executed. I don't know if this is relavent though. To check this further, I created a VB6 form with a button and some labels to display dates using the Da ...Show All