Microsoft ISV

Page 190




  • Topics
    Replies
    Last post
  • column headings in a combobox
    by CaRecycler
    2 Replies
    Last post by CaRecycler
      • I have a VBA application that fills a combo box from an array and I'd like to display column headings as well. By using columnheads = true I can reveal the headings but getting a value into that heading space is proving tiresome. Any ideas
  • Corrupted response!
    by strickz
    2 Replies
    Last post by B. Ward
      • I have one response that appears to be corrupted in some way! It is a "Product Upgrade" response and I had set the version filter to 1.0.0.0 - 3.3.1.0. However, the response also got mapped to the latest version (3.3.5.0). How can this be As you can imagine, the impact of this can be quite high since customers running the latest version were told to upgrade to a version that didnt
  • Adding alt text, name, and hyperlink to pasted images from another worksheet.
    by jrc1378
    5 Replies
    Last post by Andy Pope
      • I have a workbook with the following sheets: Display (Sheet1) Data (Sheet2) Images (Sheet4) My sub is built to read reference data from Data! that tells it to copy a certain picture from Images! and paste it onto Display! at a certain location. It also grabs a label name from Data! and puts it to the left of the image just pasted. All of this works fine, but I also need
  • MS Office document and image writer print driver
    by GTH
    14 Replies
    Last post by Mary3480
      • Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to
  • Summing up hours on form based on parameter query
    by RhysDavies
    6 Replies
    Last post by RhysDavies
      • Hi there - im finalising my new activity system but i have one issue. on an activity form i have certain fields for information purposes that are non editable - they are 'hours worked with client' , 'hours worked this month' and 'hours worked for the day'. The first 2 fields are populated automatically by opening recordsets on form load or companyname exit and summing up the hours based on the
  • VBA Graphics/Animation Help
    by Jusfocuz
    0 Replies
    Last post by Jusfocuz
      • hey everyone. I am new to the site and to VBA but not too new to the programming world. Ive been learning VBA for about a month now and Ive been able to catch on to it quickly. Now i am working on a project, a casino craps game. I finished the basic project [getting the random numbers for the dice rolls, chekin the roll, placing bets etc.] and now I am trying to make the game more attractive. i w
  • VBA and automated word generation
    by Bindhia
    2 Replies
    Last post by Bruno Yu - MSFT
      • Hi there, I am currently working on a VBA application. There is an automated word generation available in the appliacation that serves the reporting process. If there is any Flash add-in being installed in the user's machine (can be viewed through Tools->Templates and Add-ins in MS Word) ,the applicaiton crashes down when the user tries to generate the report because the flash add-in r
  • Deploying a score card to Sharepoint portal
    by RajeevRanjan
    1 Replies
    Last post by MS ISV Buddy Team
      • Hi I have installed BSM client and server . All supporting tools are installed properly..When I am trying to deploy the Sample northwind scorecard to share point site I am getting the following error. (in sharepoint site page....) Cannot create an instance of the control of type Microsoft.PerformanceManagement.Scorecards.WebParts.CustomWebPartPage. For more information, contact the serve
  • open Excell file from Access with dialogbox
    by Norbertus van der Lei
    2 Replies
    Last post by Norbertus van der Lei
      • Is it possible to open an Excell file from Access, but the file name is variabel. So I need to choose in a dialogbox open file Thanks, Norbertus van der Lei
  • Macro To Delete Spreadsheet Columns if no data in column
    by GB Allan
    8 Replies
    Last post by AussieJames
      • Hi, I need a routine that will go across and delete any columns in a spreadsheet that don't contain any data. The spreadsheet will always be from columns A:BB. There are column headings on row 1 going across. Thanks for your help - I very much appreciate this forum. It has helped me out greatly! Gary
  • Inserting Object in Excel using VB
    by Lance Clark
    1 Replies
    Last post by Shasur
      • I have a command button within a userform I am developing, which will automatically take the user to the Excel Insert Object function Private Sub CommandButton2_Click() Application.Dialogs(xlDialogInsertObject).Show End Sub What I need to understand is how, using VB script, once the user has selected the file and clicks on OK within the Insert Object function, that the selected file
  • Sub or Function not defined
    by artist0
    1 Replies
    Last post by Andy Pope
      • I came accross a strange problem. I tried to record a macro where I used Solver. After I tried to run it, I was given an error message: Compile Error: Sub or Function not defined. The function where VBA stops is "SolverOK". It is not a macro that I coded, I recorded it in the excell sheet. Thanks for any advice. Lubomir ------------------
  • Run-time error '3705'
    by ISRI
    4 Replies
    Last post by ISRI
      • I am trying to run this VB function in Access which will delete records from my table based on the criteria of another table. The code looks like this: Function deleteDuplicates() Dim FHA_Case As String Dim SeqNumber As String Dim SQL1, SQL2 As String Dim rs1 As New ADODB.Recordset Set rs1 = New ADODB.Recordset Dim rs2 As New ADODB.Recordset Set
  • New to Visual Basic
    by darnold
    5 Replies
    Last post by darnold
      • Im trying to do the following: I created some command buttons that has the number 1, 2, 3, 4 on it, like a keypad or a calculator. When I press the button I want it to give a value (variable) of 1, 2, 3, 4, etc. At the same time if I press 1 and 4 on the keypad, Id like it to indicate 14 or 9 and 8 I would get 98. What I'm trying to do is: Button 1 = 10 * (number pad syst
  • Hyperlinked URL Validation Using VBA Macros in Excel?
    by elboricua
    1 Replies
    Last post by Andy Pope
      • I have an excell spreadsheet containing hyperlinks to multiple URL residing in the WWW. I have written a VBA macros that opens each hyperlinked webpage and looks up information for each. However, sometimes the URLs are no longer valid because the pages are missing or have been moved. When this happens I receive a runtime error message. I would like my program to keep running. I would like to handl
  • Determing close method with vba
    by JS
    5 Replies
    Last post by Andy Pope
      • Hi, How can I in vba code trap which closing method the usr has used. E.g. File -> Close, File -> Exit, workbook X or application X Grateful for help. Jonas
  • HdI use Find to set a variable = column #?
    by chilehed
    2 Replies
    Last post by chilehed
      • I'm struggling with how to use the Find method. I'm trying to automate a rather complex analysis of 10 or 15 columns of data. My code needs to be able to deal with the fact that the data will often be in different columns depending on the user, but so far nothing I've tried works and it all looks clunky to boot. Would anyone be able to suggest how I could do something like Dim v
  • Sorting an array
    by une
    4 Replies
    Last post by une
      • I have have an array named punc, is there a function I can use to sort its elements Would the command be; Array.Sort(punc) it doesn't seem to work. This code did not work either and I can't work out why; Dim punc(3) As Integer punc(0) = 8 punc(1) = 7 punc(2) = 6 punc(3) = 5 Dim i As Integer Dim j As Integer Dim temp As Integer For i = 0 To 3 Step 1 For j
  • Problem encountered Microsoft Office\Office 11\Winword.exe
    by TRSMRN
    1 Replies
    Last post by MS ISV Buddy Team
      • I have installed Office 2003 on XP SP2 + Office security updates in an Intel Dual Core laptop. I uninstalled the trial version for Office 2007 and reinstall office 2003. But I am still encountering a problem when I try to open an application whith a template that uses MS Word. I receive a Box Visual c++ runtime library: Program files/Microsoft Office\ Office 11 \Winword.exe. This applicat
  • UserForm Initialize Problem
    by DeathSurfer
    1 Replies
    Last post by bi-lya
      • Duuuuudes: Is there a way to check if a userform, created with vba, running inside of Excel 03' is visible without the userforms initialize event running Thanks.
  • Select/cut/insert
    by Bluzdude
    4 Replies
    Last post by Bluzdude
      • I need to select all rows in an Excel worksheet in which the value in cell "F" is not blank, cut each of those entire rows and insert them in another worksheet at row "4".
  • Calling a function from a DLL
    by Douglas Penna
    6 Replies
    Last post by Mezhick
      • Hello there, I wrote a DLL in C++, and I'm trying to use it in Excel. When calling the the function, I used the code, at the begginning of the module: Option Explicit Public Declare Function preco _ Lib "OpcAmericanaDll.dll" _ (ByVal Spot As Double, ByVal strike As Double, ByVal Ks_fixados As Double, ByVal t_dos_strikes As Double, ByVal t_final As Double, ByVal t_inicial As
  • Count characters in a string using VBA in excel
    by Jonas.S
    3 Replies
    Last post by Jonas.S
      •  Hi all, How can I count the number of characters in a string so it works as the example below Len() works quit well but I would like it to stop on blanks. <some function> (me) ''' return 2 <some function>(me_rest) ''' return 7 <some function>(rest s) ''' return 4  Thankful for help. \Jonas  
  • Undo is not available?
    by AussieJames
    2 Replies
    Last post by AussieJames
      • Hi - I was wondering if anyone could tell me why the undo command "isn't available" in a form I'm using it as part of the cancel function on a form. When the form is called from another form to enable the user to add a new record, it is pre-populated with some info from the first form. This of course creates a record in the table using the next autonumber in the sequence. if the u
  • Highlighting a row when letters appear in cell?
    by matty101
    4 Replies
    Last post by matty101
      • I have a long section of data that needs to be broken up into 4/5 columns - which I've managed to do. Before I run the macro I have, the only data is in column A, and the macro fills in colums B to F. What I need help with, is highlighting a row (from column A to F) whenever the letters MASC appear in column C, after the first bit of my macro is run. I did try to adjust the codes I found on this t