Microsoft ISV

Page 133




  • Topics
    Replies
    Last post
  • case insensitive VBA for excel
    by Jonas.S
    2 Replies
    Last post by Jonas.S
      • Hi all, How can I make the below code case insensitive for the spelling of 'stat, Stat, STAT etc'. Any ideas how to make that happend 'ActiveSheet.Select For Each ws1 In Worksheets If ws1.Name = "STAT" Then Worksheets("STAT").Select If ws1.Name = "STAT" Then GoTo Start End If Next Thankful for help \Jonas
  • Live Communication Server 2005 SP1 - Specified backend for the pool is current in use
    by Jensan_Ahsay
    7 Replies
    Last post by Peter Gu
      • Hi, I have installed the Live Communcation Server 2005 SP1 on my x64 computer with Windows Server 2003 R2 SP2. I found that i have given the wrong name for the DNS, and therefore i am trying to re-install it. However, when doing the step "Create/Upgrade Existing Pool", it gives the error "[0xC3EC78BA] Specified backend for the pool is current in use". The error is unders
  • error -2147417851 working with VBA and Word
    by Jorge Ubeda
    6 Replies
    Last post by Jorge Ubeda
      • Hello all I¡¯m receiving an error -2147417851 when loading an html file to word: here is the code that generates such error: Set rng = doc.ActiveWindow.Selection.Range rng.InsertFile zzz.htm,, False Some directions about where locate info about error codes thaks in advance Jorge Ubeda
  • Worksheet Drag and Drop Question
    by PYA_Ferro
    1 Replies
    Last post by PYA_Ferro
      • Hello all (sorry for my english). Is there any way to drag values from a listbox in a form to a cell in a worksheet I know there is the mousemove event that can handle this between forms, but I want to do this between a form and a worksheet. Any ideas Thanks.
  • Pivot Chart - Change Sum of values to be Average of Values through VB code
    by EddiRae
    2 Replies
    Last post by EddiRae
      • I am creating my pivotchart also using VB. Below is the pivot form load. I have the chDimValues being created using the statement below. Private Sub Form_Load() Dim c As ChartSpace 'Set the Chart data. Set c = Me.ChartSpace c.SetData chDimCategories, chDataBound, strCategory c.SetData chDimCategories, chDataBound, strCategory c.SetData chDimValues, chDataBound, strData
  • I need a list of prcesses
    by BILLJO
    0 Replies
    Last post by BILLJO
      • And applications that run in the background that i can diable or cut off. I have been looking everywhere on the internet for this and cannot find it. If anyone can help please let me know. Bill Jones
  • Obtain Unique Work Units via SQL
    by AlDeb
    14 Replies
    Last post by AlDeb
      • Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals. I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits. In the example below on on
  • Returning a value from VBScript to a DOS batch file
    by scantwell
    0 Replies
    Last post by scantwell
      • Hi, I have created a dos batch file that in turn creates a vbscript file to find out the process id of a certain application. This part works perfectly but what I need to do is return that process id back to the calling batch file. How do I go about doing that TIA
  • How to make a macro to copy some parts of a table to an email that it will create?
    by kebever
    8 Replies
    Last post by kebever
      • Hi, I'm quite new to VBA but had some experience coding for Excel. I now require a macro to help me solve a problem in Word and email. I hope someone can help me here. Thanks in advance! The issue is that I need to copy some parts of a table in Word to an email that it will create too. For eg. There are two columns to the table, with the 1st row, column 1 being "Na
  • Need help
    by RUSKIE
    2 Replies
    Last post by Andy Pope
      • Hi All, I am building a macro and would be grateful if you could help me out. I cannot figure out a way how to make this work: ------------------------------------------------------------------------------------------------------------------------------------------------- b = 0 Do i = 1 + b Do While Sheets("Box Pivot").Cells(2 + i, 2).Value <> ""
  • Convert Excel sheet to PDF using VB macro in Excel
    by JamelB
    1 Replies
    Last post by Bruno Yu - MSFT
      • I am a beginner programmer trying to write a code to convert an excel sheet to a pdf file. I want to include this in an excel macro. HELP please!!!
  • Bucket ID 8, event type
    by Claus Brod
    14 Replies
    Last post by DHON
      • Hi all, on my Vista system, I generated a lot of crash reports using WER-aware code (i.e. code which explicitly uses WerReportCreate() and WerReportSubmit()). When I look at those crash reports in the Problem History window, I find that many of those crash reports have a bucket ID of 8. This doesn't look like a bucket ID as it would be assigned for a crash report which makes it to the Winqual site
  • error -2147417851 working with VBA and Word
    by Jorge Ubeda
    6 Replies
    Last post by Jorge Ubeda
      • Hello all I¡¯m receiving an error -2147417851 when loading an html file to word: here is the code that generates such error: Set rng = doc.ActiveWindow.Selection.Range rng.InsertFile zzz.htm,, False Some directions about where locate info about error codes thaks in advance Jorge Ubeda
  • ADO trouble
    by MoPatel
    1 Replies
    Last post by leeshade
      • here goes, I have created a database with username and password that excel uses to loggin user with different sign in provileges. in this database i have two tables, [USER with all usernames and password] and [GROUP containing the different user levels]. The USER table contains 4 different recordsets columns, ID, this is an autonumber LOGIN_NAME, this is the loggin name (e.g mine i
  • VBA Or Access
    by Crysallis
    2 Replies
    Last post by Crysallis
      • Currently I've written a db and on one of my forms I've used the builtin combo box tool and used it to have you select and item from the list and update the data on the form. Now on my machine I can, when I open the form, simply start typing in a number thats inthe list and it will seek to that number and I can press enter and it will update the form. Now when I do this on another machine it gi
  • Sort rows within a range
    by NewToVba
    6 Replies
    Last post by Andy Pope
      • Hi My problem is the following. I have a (100rows x 10columns) range to which some numerical output is written. I need to access each row in this range and sort it descending. Any suggestions Any help is much appreciated. Thanks. Thomas
  • DOS Command Question
    by okieflier
    3 Replies
    Last post by Derek Smyth
      • Im sure this is easier than what im trying to do, but any help would be great. The following code is from my .bat file, the problem is I have numerous file names that change on a daily basis, that I know I can programically change. Im not sure how I can send the dos command though from MS Access/VB. I don't want to use a .bat due to having to change file names. The following is what is in my .b
  • when I use the fusion technology and make the aciveX control
    by aleem076
    0 Replies
    Last post by aleem076
      • Dear Sir, I have a web application using DSO Framer c ontrol, but when my client wants to view the page. He has to make his security settings low. I know that when I use the fusion technology and make the aciveX control as Windows control and display it by using <OBJECT> tag, then it will act as a normal .net control, can any one help me to do this. Youn can even mail me to : aleem_abdul
  • Macro in excel
    by Paul Ked
    1 Replies
    Last post by bi-lya
      • Hi I could do with a bit help. I have created a macro in excel that is basically this; Sub auto_open() ThisWorkbook.Worksheets("Aftersales").OnEntry = "DidCellsChange" End Sub Sub DidCellsChange() Dim KeyCells As String Dim cells, tmpStr As String cells = range("A38").Text Here = ActiveCell.Address MyColumn = Mid(Here, In
  • Refreshing Data
    by jlave
    0 Replies
    Last post by jlave
      • I am new to writing code, so this is one of many baby steps. I am using VB Express 2005, with a Sql Express 2005 database. I have 2 joined tables, and I have made a form that displays data from the parent table. The same form displays data from the child table. The problem I am having is that when I navigate to new records using the BindingNavigator, the child data is not refreshed.
  • redim
    by Derek at Potters Clay
    7 Replies
    Last post by blackmamba
      • I am trying to create an application that declares a 2 dimensional array queuegoals(0,0). Later in the code, I am finding out how big the array needs to be and i want to resize it so I am trying to use redim preserve queuegoals(maxproduct,maxqueue) but i keep getting and error of array already dimensionized. How can I redimension this array
  • Runtime Error '2001'
    by Mona_D
    6 Replies
    Last post by cobolisdead
      • I am using the following code to use an unbound text box to display the PM Name associated with the PM Number but for whatever reason, I keep getting the Runtime Error '2001' when I run the code. Private Sub Combo59_AfterUpdate() Dim StrName As String Dim strPM_Select As String strPM_Select = "[PM Number]=" & Me![Combo59] & "" StrName = DLookup("[Plan_Center_Nam
  • Problem with events
    by Keithyboy1
    3 Replies
    Last post by Keithyboy1
      • I have created a customised control in a class module, which works in a similar way to a combo box. It consists of a label, on which I have a button. When the button is clicked, a frame control appears below in a similar fashion to a combo drop down pane, on which I have various check boxes which a user can check or uncheck as required. The button click event basically sets the visible property of
  • WorksheetFunction Object help needed
    by Rakesh Simpi
    4 Replies
    Last post by rakesh
      • i am trying to use WorksheetFunction object to calculate R-Square (linear regression) value. Now, if i export my numeric data to cells of a worksheet and use Value2 function, i get an appropriate answer. But, if i try to use WorksheetFunction object by passing my arrays of integer, it gives me some spurious result which seems to be completely irrelavant. here is my sample code: dim Appp as new Exc
  • Code Snippet Manager for VBA
    by jameyer
    2 Replies
    Last post by Derek Smyth
      • I am, for the moment, still writing my VBA code in Excel (and possibly soon word). I find that I use some code repeatedly. Is there any free code snippet manager for the VBA IDE