Answer Questions

• new people What is the difference between Excel Dates and VBA Dates ?

  Dear all, In this piece of Excel VBA code: Sub a() Dim Datim As Date Dim Outr As Range     Set Outr = Range("b2")     Datim = "17/03/2006 12:00"     Do         Outr.Value = Datim retry:         If Abs(Datim - Outr) > 0.0000001 Then             Debug.Assert False &nb ...Show All

• Boris Mueller download a file via internet and save it locally

  Hi, I would like to have a script that download a file (a word document) from internet (http/https) and save it on local PC. I've already found how to download a file: ************************************************************ Dim WinHttpReq Set WinHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1") WinHttpReq.Open "GET", "http://", False ************************************************************ but then, I don't know how to save th ...Show All

• Hades255 Why Excel 2003 keeps PivotItems with zero record count after refresh?

  After a pivot table is refreshed, if some pivot item is no long exist in a pivot field, the pivot field drop selection still show that pivot item to allow user to select.  Selecting this kind of pivot item will lead to no data showing at all. This is no good. I perfer Excel will remove zero record count pivot item from the pivot field drop down selection box after a refresh. (I don't mind Excel keeping zero record count pivot item inte ...Show All

• avatary2k Automaticly updating charts in excel

  You guys (well mostly Derek) have been so helpful. I have everything but one thing working in my Excel file. I still can't get the charts to update when new information is put into the spreadsheet (I am using a form to fill in the cells with the data inputted). Now I have been basing all of this on a spreadsheet that already does this function. There is one major diffrence in that spreadsheet's charts and the one I am doing. Th ...Show All

• Secor_BobF Collating Data from Multiple Excel Sheets

  Hello, My manager has given me a project of collecting skills of all the employees. I have made and sent out a Excel sheet for employees to fill and send it back to me. It asks the Empployee to enter the following details Employee Name: Employee ID: Date of updattion: There is whole list of skills against which they have to Self Rating (Scale of 1 to 3) Mention the Level of experience (A,B,C,D) Training Undergone (Interna ...Show All

• wizkid1 XSL applied with VBA

  Hello, everybody, Derek, Brenda Acctually I'm doing a test based in Instructional program evaluation faced with library resources. The goal of these evaluationsis to assess the adequacy of library resources to the needs of courses offered within a program and to determine the ability of the library to support teaching and related research. This methodology of collection evaluation based on the analysis of the content of individua ...Show All

• Dany V Problem in Saving Excel 2003 Workbook in Excel 97

  Hi all, I am experienced that when i saved a workbook in Excel 2003, then save the workbook in Excel 97 running the VBA code, it will prompt a message about: "This file was created using a later version of Microsoft Excel. If you save this file using Microsoft Excel 97, information created with features in the later version may be lost. ............................................................. -To continue with the Save, click ...Show All

• Urban Jiri Using VB in Excel 2003

  Can anyone help me rework this code. What I need is the code to call four columns. First is a name column. Then a space then 3 numbers separated by slashes each with a different rule for coloring. So example let’s say name is Smith I want Smith 32/15/3.4 And the column where 32 comes from let’s say has parameters 20+ is green, 15-19 is black, 10-14 is red and below 10 is plum and bold. Second column number would be similar e ...Show All

• evarlast Extended Development Team Set-up for ISVs

  We are a team of industry veterans with more than 14 years solid industry experience each, who have set-up high-performing offshore and on-shore Extended Software Development Teams specifically to serve the ISV communities. We have achieved nearly 40% net-margin improvements for our client organisations in almost all the occasions. Our most recent venture was totally focusing on Microsoft .NET domain. Currently, we are looking for inter ...Show All

• mspence Installing VBA6.0 on XP

  Good morning and hello.   Ages ago I received a SDK 6.1 containing the latest release of VBA 6.0. I happily and without problem installed this on my laptop running Windows ME and all was well. I have since updated my laptop to one running Windows XP Home and when I went to install the SDK I was confronted with an error stating that "....You first must install Microsoft Visual Basic 6.0 Service Pack 3 to install the VBA ...Show All

• Carvin format numbers in html

  How do I insert the Grouping Separator in my HTML code for the body of an Outlook message so that there is a comma, "," every three digits, like in 1,234,567 The following code produces a table where the numbers are not formatted as required: .HTMLBody = "<HTML><BODY><B>" & side & Sheet2.Cells(14, 14) & "</b><br></br> " & _ "<UL><TABLE bo ...Show All

• Rory Bannon Using KPIUtil, cannot export KPI from SQL Server 2005 Analysis Services to BSM and vice-versa

  I am trying to export KPIs created in Analyysis Services to BSM using KPIUtil. I have KPIUtil installed on my machine which has the following: Windows 2003 with SP1 Microsoft .NET Framework 2.0 Common Language Runtime 2.0 Analysis Management Objects Microsoft Office Business Scorecard Builder 2005 The BSM Server is on a separate machine. The scorecards created using BSM(without KPIUtil) work fine. In the KPIUtil-New Confi ...Show All

• chad_ How to read a URL?

  hi, i want to read a URL into an excel macro, ( it's asp page that i want to download to search for specific fields to store in the excel sheet) anyone could help Hi, Excel macros are very powerful and you have the freedom to use a lot of stuff there. So you may create a new instance of the Msxml2.XMLHTTP and gets a http response like in JavaScript or any other application. A sample code is ...Show All

• Mali313 Access and TransferText

  I'm working on an export project from Access, and the export wors fine in one of two instances: A. I can use a spec that was saved via the import/export wizard and get a fixed length, B. I can use a delimited without a spec and that works, but not with the desired layout. I really need a fixed lenght output, but I need this VBA to be transportable to other external systems. So the question is, can a spec be created on the fly, like I ...Show All

• DLLarson How to read directory information into a combobox.

  Hi, I have a requirement to list all subdirectories under a specified directory in a combobox. - Srini. Hello Srini A couple of questions first: 1) What application are you using 2) What version of that application are you using 3) What platform are you using, Windows, or Mac Have you checked the FileSystem Object You could do something like what you are asking using the FileSystem Object model. Hope th ...Show All