Microsoft ISV

Page 118




  • Topics
    Replies
    Last post
  • dll's in VBA
    by Keithyboy1
    1 Replies
    Last post by Douglas Penna
      • Currently in my VBA programs, I'm finding myself repeating a lot of code and functionality across different projects, and it would be great from a maintenance point of view if I could create something similar to a .dll, that I could import into a project and use. Furthermore, if circumstances change and I need to change how a sub-routine works in the .dll for example, all projects using it will be
  • How to delete a connection?
    by gein
    5 Replies
    Last post by JohanBark
      • Hi, this is my first post here. I'm having some difficulties with Excel 2007. I'm creating Connections (URL based) on the fly in VBA. The code for that looks like this: fId = Trim(Str(Target.Value)) Set QT = ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://here-the-address-to-the-location/ id=" & fId _ , Destination:=Target.Offset(-1, 2))
  • Action Pack Question
    by Tone Southerland
    12 Replies
    Last post by Mark.Rowe
      • I am interested in the Action Pack. I understand that it comes with the Vista upgrade, not the full edition. I do not have 10 licensed copies of XP Pro to upgrade from. So does that mean I will need to purchase a licensed copy of XP Pro for each machine that I want to put the Action Pack upgrade version of Vista on
  • WoksheetFunction Doesn't Work With Currency Range
    by Qingping Cheng
    2 Replies
    Last post by Qingping Cheng
      • Hi All, I got a probelm with Excel VBA. I have a range named as "MyRange" with currency data. I would like to add up all currency numbers in the range. I used the following codes: Dim MyRange Dim MyCurrency MyRange=Range("A1:A3") MyCurrency=Application.WorksheetFunction.Sum(MyRange) MyCurrency returns only 0 whatever currency values in MyRange.
  • VB to MS Acess (ASNI To UTF8)
    by faizan ul hassan
    0 Replies
    Last post by faizan ul hassan
      • what can i do i develop URDU language software in VB 6.0 but when i stor record from VB to Acess Database it is not in UTF8 can any one help me how can i stor records in Acess MDB via VB 6.0 in ANSI to UTF8 fromat plz help
  • Alphabetize upon concatenate
    by bpc21
    2 Replies
    Last post by bpc21
      • In Excel 2003, I have two columns of information (intersection street names) Oak and Main for example. I would like to combine the information into one cell seperated by an ampersand (Main & Oak). I need to alphabetize the street names upon concatenation so that Main always lists before Oak. Suggestions Any advice is appreciated. BPC
  • Runtime Error 1004
    by akn112
    5 Replies
    Last post by akn112
      • I think i've asked on almost every VBA forum Here's the error code im getting: Method 'Range' of object '_Global' Failed It comes every second time i run the code. Originally i thought it had something to do with the variables. But i have set my code to set my variables to nothing at the top and bottom of my code. I also close the application and close the workbook. This code should 1) op
  • need to access my old email account at Email: burns2596@sbcglobal.net
    by Ralph Burns
    2 Replies
    Last post by Carole Pennisi
      • I need help with veiwing my old internet Email account: burns2596@sbcglobal.net . Please, help.
  • 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
  • Anomalous results with STDEV command
    by chilehed
    2 Replies
    Last post by chilehed
      • When calculating standard deviation using the Application.StDev command, the value returned is different than when pasting the =AVERAGE() command directly into the cell, UNLESS all of the data entries have the same value. I'm probably doing something stupid - but I can't find it. Put a series of numbers in cells B7:B32 Code: '''''''''''''''''''''''''''''''''''''''''''''''''
  • Publishing BSM Scorecard programmatically
    by bayofbengal
    1 Replies
    Last post by MS ISV Buddy Team
      • Hello, I need to publish BSM Scorecards programmatically in a BSM Server. How, if possible, can I use the web service to do the same. Or is there any other way to do the same
  • VBA with powerpoint 2007
    by rutuja
    2 Replies
    Last post by rutuja
      • I want to pick up text and then differenciate between colors on the slide I am doing the same using VBA in ppt 2003 using the code If .Font.Color.RGB <> 0 Then sFontColor = "color:" & GetColorCode(.Font.Color.RGB) & ";" Else sFontColor = "" End If but if i try to do the same thing in ppt 2007 it doesnot work for all
  • Status on MSDN service (site down?)
    by skaue
    1 Replies
    Last post by MS ISV Buddy Team
      • I couldnt find a proper place to post this, but I'm trying here first. My company is Empower so I have access to MSDN Premium. However lately I've been unable to access the pages where you can see product keys and download dev tools. After a quick call to support a lady there told me the service were having technical difficulties and I should try again later. I did this morning and now its u
  • DAO can't connect to Access2007
    by Haojun
    3 Replies
    Last post by Venkat M
      • Hi all, I'm using DAO to connect to an Access2007 database file. But it reports such an error "unrecognized database format". Does anyone know if MS supports using DAO connect to Access2007 Is there a new release of MDAC along with its Office2007 Thanks in advance, - Haojun
  • How to override windows settings using macros in excel-urgent help
    by arunnc84
    3 Replies
    Last post by arunnc84
      • Hi guys, i had written a macro to get a date value and convert it to the date format which i need using the below code. date = Format(tempworksheet.Cells(1, 1).Value, "yyyy-mmm-dd"). it is getting converted fine when the regional language is US(English).When i change the language to czech it is not getting converted fine.The month is taken as date and date as month i.e if i enter 06/05/2
  • Excel UserForm - TextBoxes - can't load data on open
    by suznal
    14 Replies
    Last post by Cringing Dragon
      • I have a UserForm that contains several textboxes used to display data from a worksheet. I want the data to load and be visible when the userform opens, currently I have to tab through the TextBoxes to get the values to show. I would like to know what event (I can't seem to find one) will load the data when the UserForm opens and require no user input to display. Sample code for the first th
  • How to activate a listbox selection using Excel VBA?
    by Kven
    14 Replies
    Last post by Andy Pope
      • Hi, I am very new to VBA Progamming. I have created a tool which checks for error in excel file. The below is my problem. First i will select a file using Openfile method. Then the combobox will display all the sheets which are present in the selected excel file. Here i will select a excel sheet and run a code to check errors. The procedure will check the errors and shows how many errors
  • unable to enter data in textbox- Access 2000
    by synergeticsoul
    0 Replies
    Last post by synergeticsoul
      • i am unable to enter a numeric value in a textbox. i converted a db from 97 to 2000. i just read that there may be some conversion problems and in particular one of the problems lies with the text boxes. microsoft instructs users to remove the textbox and then re-add it. i did that, changed the control so that it was unbound too, still can't enter anything. any suggestions how i can overcome this
  • Check if an Excel workbook is opened and in use by somebody else
    by Perwel
    3 Replies
    Last post by Andy Pope
      • Hi, I need to check if a workbook is opened and in use by someone else. workbooks.open does not return a trappable error
  • Tough keyboard?
    by darkfeffy
    1 Replies
    Last post by Claus Brod
      • I own a Toshiba Satellite which runs a Windows XP Home Edition SP2. As well, I have an HP tower running a Windows XP Pro SP2. On both computers I use a physical French keyboard. Often I change it into a US keyboard on the language icon of the task bar of the Windows operating system for my word processing needs. The fun is lately I can't swap back to French on the keyboards of both computers. When
  • Hiding Access Application Window
    by Keithyboy1
    4 Replies
    Last post by palaemon
      • Hi Everyone! Apologies in advance for the long thread! I have an Access database, which I have developed to monitor and track assets issued to employees, and it is intended to be used by others, as opposed to myself. It therefore makes heavy use of forms in order to provide a friendly user interface for non-technical people. To really polish the application off, I want to be able to compl
  • Excel UserForm - TextBoxes - can't load data on open
    by suznal
    14 Replies
    Last post by Cringing Dragon
      • I have a UserForm that contains several textboxes used to display data from a worksheet. I want the data to load and be visible when the userform opens, currently I have to tab through the TextBoxes to get the values to show. I would like to know what event (I can't seem to find one) will load the data when the UserForm opens and require no user input to display. Sample code for the first th
  • VBA macro to replace
    by sree
    5 Replies
    Last post by sree
      • Hi I have two worksheets in a workbook, In sheet 1, i have columns Sector level 2 and 3, for some enterprises In Sheet 2, i have columns sector level 1, for the same enterprises, I wish to create a macro, which would look for corresponding enterprises which is the only common element in both sheets and then it should replace corresponding sector level 2 with sector level 1
  • Find Conditional Formatting in Excel (2003)
    by Kit557236
    1 Replies
    Last post by Andy Pope
      • I had someone pass me a spreadsheet with conditional formatting all through it and they wanted a list put together showing The Item, old value and new value that didn't match e.g. conditional format = true. They had used Cell Shading color 8421631 (or Colorindex 22). Not a problem... or was there If mws2.Cells(iRow, iCol).Interior.Color = 8421631 Then cc
  • VBA help with a conditional Subscript out of Range
    by Robbie Deal
    2 Replies
    Last post by Robbie Deal
      • Hey everyone, Hopefully this one will be an easy one. I am asking VBA to pull information from an access 2003 database, and place it in an array. There are cases when I know that I will get a "Subscript out of Range" Error, and have to ask for a different set of values, due to having 0 values in the database for the parameters I asked for. IE no values in this table for that date r