Answer Questions

• e. ogas Search list

  Hello! I have a small problem that I do not know exactly how to solve. I have a macro that that searches a list in Excel for a certain date e.g. 2006-02-14. The date is stored in the array strSlutDatumArray(1). I look using rng(1).Offset(j, 0) (never mind that but it just loops down in a list). I apply this code on many lists. Almost all lists consist of dates based on a 5 day week. However some lists only contain one date per week. Assume that I am searching for the date 2006-01-10. The lists contain only 1 date per week. I want to somehow check so that I choose the date closest to 2006-01-10 in the list. Assume that the list looks like: 2006-01-01 2006-01-08 2006-01-15 Then I want to stop my se ...Show All

• Ahmet CAN Is There a VBA Documenter

  Wondering if anyone knew of any FREE Documenting software out there for vba. Other than the one in Access. I don't like Access Documenter because it doesn't show methods I am looking for a documenter similar to this style: ClassModuleName: Public FunctionName () as VarType Private MethodName () Public MethodName2 () ClassModuleName2: Public FunctionName () as VarType Private MethodName () Hi, I don't think there is one, or at least I haven't came across one. You can create your own though fairly easily using the code example at this link... http://www.cpearson.com/excel/vbe.htm Try Rob Bovey's Code Documentor. http://www.appspro.com/Utilities/Documentor.h ...Show All

• Adam Miles Problem regarding VBA in excel - Combine 52 VBA codes for 52 weeks in a year to one VBA code

  I am very new to VBA, hope that anyone can help me on this.. I have some problem with creating a code which can Please refer to the code down there: 'the listbox will show week 1 to week 52 and let me choose one of the week. Private Sub OKButton_Click() If ListBox1.Text = "Week 26" Then Call week26 If ListBox1.Text = "Week 27" Then Call week27 ' all together 52 weeks in a year Unload Me Sheet7.Activate End Sub Sub week26() With Sheet7 .AutoFilterMode = False .Range("A1:I1").AutoFilter .Range("A1:I1").AutoFilter Field:=3, Criteria1:=">=26-Jun-06", _ Operator:=xlAnd, Criteria2:="<=2-Jul-06" End With End Sub Sub week27( ...Show All

• Yuki Chen macro for automatically creating data labels in excel chart

  Hi all, I'd like to write a macro in for excel to create automatically a chart, i have no experience in this field. I use the following code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8-6-2006 by CTW ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R2C1" ActiveChart.SeriesCollection(1).Values = "=Sheet1!R1C2:R2C2" End Sub This code works well, but i want the following to do: every time pressing Ctrl+m I want the used data for the chart move 2 rows below, so I can visually scroll through the data. for example: Ctrl+m gives chart of: x value: Sheet1!R1C1:R2C1" ...Show All

• Marie-Th&amp;#233;r&amp;#232;se Running a macro if new mail if from a specific address

  Hello, I'm currently trying to write a macro that is run when new mail is received in Outlook 2002 (possibly XP not sure though) I would like the macro to check if the new email is from a specific address (in this case sales@falcontrunking.co.uk ), delete the email, and display a message saying "There is a new message in the Sales Inbox". I know how to run a macro when a new message is received and I know how to show a message box saying "There is a new message in the Sales Inbox" but I don't know how to check if the new message has been received from a specific address. Can anyone help me This should do what you're looking for. You may need to adapt it slightly to fit you ...Show All

• Kristof.Taveirne Picture Question

  At what stage does a "Picture" become valid If I use the LoadPicture method I can then use PaintPicture to move the image (or parts of it) to other Pictures but if I just draw on a Picture object (line, shape etc) any attempt to use that Picture as a source (eg PaintPicture to another Picture) results in an invalid picture error message and the source Picture is indeed zero. Am I missing something here If this behavior is "normal", just how do you copy the contents of a "created" Picture( ie not loaded) from one Picture object to another, eg Form1.picture to Form2.picture ...Show All

• KentaroM New CRM 3.0 Blog - http://4mscrm.g-s.co.il

  New CRM 3.0 Blog - http://4mscrm.g-s.co.il This site managed by Guardian Information Systems - one of Leading CRM & SharePoint service providers in Israel. Read more (hebrew) @ http://www.g-s.co.il ...Show All

• spshah Find and Replace Carriage Return in Excel with VBA

  Hi all, I need to find all <CR> character (carriage return) because when I export a table from Access to Excel, the data contains "[]" that are carriage returns. so i need to find these characters and replace with null can i do this with vba many thanks Hi, you could try something like this: Dim objExcel As Excel.Application ' Excel object Dim wbkTemp As Excel.Workbook ' Workbook Dim wksTemp as Excel.Worksheet ' Worksheet ' Open record sets and objects Set objExcel = CreateObject("Excel.Application") Set wbkTemp = objExcel.Workbooks.Open(C:\Temp.xls) Set wksTemp = wbkTemp.Worksheets(strQuery) wksTemp.Activate wksTemp.Range("A2: ...Show All

• sarika OPC and C#

  I am trying to develop an OPC client using C# 2005, should I use the Automation Wrapper provided by the OPC foundation or is there a better way. For the easiest and most reliable OPC connections in C# 2005 applications I suggest our OPC Controls.NET product. The central data communications runs as a Windows Service and the components for your application are all 100% managed. You cannot achieve 100% managed application with direct OPC connections. Visit www.opcsystems.com for more information. Ken Eldridge, Open Automation Software You can use the Automation Wrapper with C#. It's fairly quick and easy to get an OPC client put together that way. If you are creating a more 'industrial stren ...Show All

• dni Count and display in cell

  Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger Hello, Try the following code: You could ...Show All

• mikewo Compatibility Issue Excel 2000 and Excel 2003

  I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up. So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I live in the US and the customer lives in the UK. When he runs the macros it immediately goes into the debugging window and highlights a bit of code that simply references the path of the existing folder to a variable. The exact code is: DestFolder = ThisWorkbook.Path & "\" There is a compile error with a message that the data fold ...Show All

• cverdon personalized command bar disappears when minimizing excel

  This is my first message in this forum, so please be patient. I have programmed a makro for an excel workbook. one part of this makro creates a command bar. when the excel workbook is started i make all the regular command bars disappear, only mine is left. Works wonderful. Well, i have put a button into my command bar to minimize the application. However, when i restore the workbook again from the windows taskbar, my commandbar is vanished, and the normal command bars (like standard and format and also the formula bar) are suddenly there. The command bar is still there but not enabled/visible. The problem exists on many computers and also on differnet excel versions i tried (97, 2000, xp) I do not know if that is a bug or not. Now is it p ...Show All

• TrD insert column after pivot table

  Using a VBA macro, I am creating a pivot table based on text read in from a tab delimited text file. After the pivot table is created, I need to add a column on the worksheet after the pivot table. Is this possible Thanks, Mike Hi Mike <<Using a VBA macro, I am creating a pivot table based on text read in from a tab delimited text file. After the pivot table is created, I need to add a column on the worksheet after the pivot table. Is this possible >> Since you still haven't gotten an answer here, try asking the Excel specialists in the Excel programming newsgroup, here: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.ex cel.programming&lang=en&cr=US <http ...Show All

• nate-d-o-double-g Trouble installing BSM Reporting Service

  I have a server with both SQL Server 2000 and 2005. And on this server I have SQL 2005 Reporting Service set up. When installing the BSM Software, it fails to see that I have SQL 2005 Reporting and says I do not have SQL 2000 Reporting Service installed. How can I get around this We do not have 2000 Reporting Service. Thanks Anyone have a suggestion for this BSM 2005 will indeed support Reporting Services 2005: Please follow this official link for Instructions for installing Microsoft Office Business Scorecard Manager 2005 with Microsoft SQL Server 2005 http://office.microsoft.com/en-us/assistance/HA101056881033.aspx Follow Installing Prereq ...Show All

• JIM.H. Left, Mid and Right functions not working on Office 2003

  Hi, VB in office 2003 does not seem to recognise the Left, Mid and Right functions. I've been using the code below to convert dates in excel like "20060123" to an actual date (i.e. 23/01/2006) in previous versions with no problem. Sub DCDecToKhanya() Dim mycell For Each mycell In Selection 'For each cell in the range selected mycell = DateValue(Left(mycell, 4) & "/" & Mid(mycell, 5, 2) & "/" & Right(mycell, 2)) 'Convert the contents to a date Next mycell End Sub I get a Compile Error " Can't find project or library" Thanks Hi, Please check "Tools > References" in VBA editor for any missing dlls. bvr ...Show All