Answer Questions

• Jupp Colored Named Ranges

  Hi, Am trying to color a particular cell in an excel sheet based on the values of other cells. For eg i have the value 10 in cells a2 till a10.I want the macro to scroll through these values and compare each one of them with a cell in the same worksheet(say F2) which has a value of 10.If all the values in the range a2 till a10 are 10 then color F2 with green.If one or more cells in Range("a2:a10") are not equal to the value of Range("F2") ...Show All

• psot Setting ASP.NET Configuration in IIS

  hi, im currently working in setup and deployment project using custom installation with System.Configuration.Install; a have already created several custom installation classes, but i have one problem. my deployment includes 2 different versions of .NET which is 1.1 and 2.0. i have created everything including modification of web.config, installation of databases, and Creating Website, Virtual Directory and Application Pool ...Show All

• Leon247 Runtime error '13' - type mismatch problem! Again...

  Hey all Thanks to the help of the forums here i thought i had most of my code working however, this infamous 'runtime error 13' keeps cropping its head up on only 2 of my 10 sub routines! :( Ive spent most of my work day searching through forums and google but i am no closer to finding a solution. The 2 functions that it is affecting are important and i need to get them sorted else i may as well scrap my two days work! Ive posted the co ...Show All

• James Briant 2 .Net and DoD/NSA acceptance

  I don't know if this is the right place, but . . . This comes from the Windows 2003/XP/2000 Addendum V5R1 DISA Field Security Operations Dated 29 August 2005 Developed by DISA for the DOD UNCLASSIFIED Page 34 8.1.4 .NET Framework The Microsoft .NET Framework, also referred to as the Common Language Runtime (CLR), provides an operating environment similar to the Java Runtime Engine (JRE). Programs written and compiled ...Show All

• Dale_Burrell Excel memory issues

  Hello everyone, I have been involved in the development in a graphical user interface which is used to sort large amounts of data, (thousands of rows, 30 columns). After sorting the data according to required ranges on column data, the columns can be plotted with any column against any other column. The number of plots can reach the hundreds and are displayed in a half-sqaure fashion. Anyway, I originally needed only 10,000 or so rows of ...Show All

• .NETBloake Getting the formatted cell value

  Okay, I need to get the formated cell value from a worksheet. For example: Looking at the worksheet the value of a cell is shown as: 12,000 Of course, if I get Cells(1,1).Value and print it to a text file or whatever, the printed value is: 12000 The issue is that I have to keep the comma so as of now I have to write a sub to put the commas back in. Is thre an easier way This'll do it: cellValue = ActiveCell.Value numFo ...Show All

• Praj VS2005: Any more CTP or RC builds to come?

  VS Release Team, I've searched these forums and have even researched a number of blogs, but I haven't been able to find out when the next VS2005 drops will be. I'm currently using the July CTP for VS2005 Pro, and am tracking a number of issues with my current development project that I'm hoping will be resolved in future RTM builds, either within Visual Studio itself (e.g., Forms designer), or as a result to fixes in the Framework. Could somebod ...Show All

• Zach First Serial Port communication from Excel 2003

  I am trying to write a simple VBA macro that reads Text data from a Serial port and puts it into an Excel 2003 spread sheet. The solution needs to work from a standard installation of Office 2003. I cannot use add-in modules since the envrioment has been locked by the SysAdmin. Can I make calls to windows API to communicate with the port from Excel Is there some sample VBA code that shows how to do this ...Show All

• sagarsinh Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• Fylar Charts.Add method causing error

  I needed a macro to add a chart with a very specific format. I created a macro that usually works, but I am getting an error that I don't understand. Here is a snippet from the macro: Set chartRange = Selection Charts.Add ' This line results in a "Type Mismatch Error" the first time it is run ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=chartRange, PlotBy:=xlColumns '... When I open a new sheet, and put some data in an ...Show All

• BCooper Challenging Topic: Online Gaming Portals!

  This is one topic that I have not found any resources on. I am interested to know if any ISVs have actually designed any gaming portals, something similar to msngames.com or pogo.com, further to that, I am interested in knowing more about the architecture of such gaming portals. I hope architects be among those who reply ;) I am wondering, why are the architects not replying :) ...Show All

• Gnidde VB Excel - userinput -> UserForms

  I have made a program that has to take userinput from Multipage UserForm and place it into a spreadsheat, the user wont see the spreadsheet, because in the end all the result will appear in a listbox in the Multipage UserForms last page. My questions: 1. If the user forgets to put information into a txtbox or a combobox, how can I get the program to tell it to the user 2. Two of the txtboxes the user has to put in values, and one of th ...Show All

• Arun Kumar How to handle CLOB Data in VBA for Excel?

  Please, somebody, I need ASAP a solution to handle CLOB Data in VBA. I need to pick a String variable and insert and update it in a CLOB field. I need also, to store whatever is in the CLOB field in a string Variable. Does anyone know how to do it Thanks! Here's the latest from our support engineer: Would you please ask our ISV to try the code below The VB6 Code: Set objCMD = New ADODB.Com ...Show All

• william c To dim or not to dim

  I am writing some code in VBA without using the Dim command for many variables. It seems to be working fine. Other than perhaps a more efficient allocation of memory, what are the advantages of declaring the type of a variable prior to use You can do that because you haven't added the Option Strict or Option Explicit option to your macro file. When these aren't used then you can just use vari ...Show All

• liljester Browsing Selection.InlineShapes forces Word to crash

  In Visual Basic Editor/Debugger: If I Trap when a Selection is made of an Inline Shape, and then try to browse the selection, Word crashes when I try to open the selected InlineShape: Sel.InlineShapes.Item(1) Anybody have an idea why that happens and what I can do to avoid this Thanks :-)an Little clarification I am not talking about browsing throught code, I am talking about browsing ...Show All