Microsoft ISV

Page 201




  • Topics
    Replies
    Last post
  • Creating and Editing Microsoft Access Reports using Visual Basic
    by bennymacca
    3 Replies
    Last post by bennymacca
      • Hi, I am trying to create a report based on the selection from a combo box in a form. i have some data, of which one of the fields is callled "projects". the combo box selects selects a project, and i would like to be able to open a report showing the data that belongs to the specific project on the click of a button. i have written the code below, but the report is only ever bl
  • 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))
  • Passing Function As Argument
    by Douglas Penna
    4 Replies
    Last post by Douglas Penna
      • I dunno if it's possible, but I'd like to pass a function name as an argument to a function. The idea is to use the result of the function to do some calculations, no matter what the function is. It would be like this: Function Find_Zeros( Function_Name As Function, Value_X As Double, etc) Thanks in advance.
  • Excel import
    by Rod Wing
    3 Replies
    Last post by Rod Wing
      • I have a working Excel vba that imports about 50,000 cell values from a variety of different text files into numerous worksheets. The problem is it is painfully slow, taking over an hour to run. The main time killer is populating each individual cell using the format: Worksheet.Cells(row,col).Value = strValue Commenting out these lines of code the program runs in under a minute. I've
  • Sum of columns
    by Sreeja561936
    1 Replies
    Last post by Keithyboy1
      • hi, I want to get the sum of a perticular column.. however the column range may differ .. so first i need to check the no. of rec in the column and then add them .... pls help
  • Problem on passing an Array to a web service
    by Dan_Dy
    5 Replies
    Last post by John Oliver (UK)MSP, VSIP
      • Hi, I¡¯m stuck in figuring out how to pass the array for KeyValueMap in the XML below for a prticular web service I am trying to invoke. ANY HELP WOULD BE MUCH APPRECIATED! I¡¯m using Microsoft office 2003 and I¡¯ve downloaded and installed Microsoft Office 2003 Web Services Toolkit 2.01 into into my PC. At the bottom of this message is the content of the WSDL which I
  • Variable scoping in Excel VBA macros
    by Wewake
    3 Replies
    Last post by Andy Pope
      • Hi All, I am developing an Excel VBA macro to retrieve the Inventory details from Mainframe sessions and writing the output in the same excel workbook as a last sheet. I am getting problem in the rowCounter variable, the one I am using it to position the row in the output excel sheet. I am initializing the counter value to 2 because I have my header as my first row.
  • Configuration Failed
    by NaveenPN
    2 Replies
    Last post by Mica
      • Configuration Failed One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure: Failed to initialize SharePoint Products and Technologies upgrade. An exception of type System.Collections.Generic.KeyNotFoundException was thrown.Addi
  • Beginner in VBA
    by VBNewby
    2 Replies
    Last post by VBNewby
      • I'm using a macro that runs before saving the workbook and allows the user to spell check each individual protected worksheet. How do I also allow the user to be able to format cells, format rows and insert rows while still doing what it is already doing Please see the code below that I am currently using...I can't figure out how to modify as stated above.... Private Sub Workbook_BeforeSav
  • Problem on passing an Array to a web service
    by Dan_Dy
    5 Replies
    Last post by John Oliver (UK)MSP, VSIP
      • Hi, I¡¯m stuck in figuring out how to pass the array for KeyValueMap in the XML below for a prticular web service I am trying to invoke. ANY HELP WOULD BE MUCH APPRECIATED! I¡¯m using Microsoft office 2003 and I¡¯ve downloaded and installed Microsoft Office 2003 Web Services Toolkit 2.01 into into my PC. At the bottom of this message is the content of the WSDL which I
  • can I write word macro with visual basic 6?
    by nta1
    5 Replies
    Last post by Rod Wing
      • I have a GUI application written in Visual basic 6.0, is there any to import it into word so that it will be a macro
  • Enhancing Menu Bars
    by Woody2
    0 Replies
    Last post by Woody2
      • I am looking for a way to make my cutom menu bar STAND OUT from all the other Excel menu/tool bars. Is there a way to change either the background color or the font color or even add an icon/picture to the beginning of the menu bar to make it unique from all the others Thanks Woody2
  • Change Column Letters to column Numbers
    by pedrohern
    1 Replies
    Last post by Andy Pope
      • Hello, I'm trying to change the Column letter input to column number... I need to work with column numbers but to make it easier to the user and avoid to count the number of column... I want to just enter the letter...
  • Cell Equal To EXACT Value
    by Donaghy
    5 Replies
    Last post by Donaghy
      • Hi all, prob a very simple question for you guys. How do you check if a cell equals an exact value of "Product" I am currently using: Cells(i, 1).Text = "PRODUCT" though this is also picking up any cell which contains the word Product, such as cells which contain the word Production. So how do you check for an exact value
  • WinQual bucket ID meaning
    by YCY
    5 Replies
    Last post by B. Ward
      • How does the WinQual generate the bucket ID What's the meaning of the bucket ID Does it represent the stack info Could someone give me an example about this When there is a crash, what files (info) get send to WinQual I am new to the WER and WinQual.Thanks.
  • Can the Native Wifi (WLAN) installer for XP be redistributed?
    by JimInTexas
    4 Replies
    Last post by Tamas Zadori
      • Can the installer described by KB 918997 be redistributed with my commerical application I've spent an hour reviewing everything I can find on this installer and can't find redistribution addressed. thanks, Jim Howard
  • If and find expressions
    by Ronan OK
    1 Replies
    Last post by Spidermans_DarkSide - MSP, VSI
      • Hello I am trying to use an If statement to find an piece of text and then go to the cell that contains that text. I have, as part of the if statement, an else statement that just cancels the expression and does something else if it cant find the iece of text. However, the expression doesnt seem to work when VB cant find any cell with the specific text and it just comes back with a run time err
  • Different ways of reports generation in excel using .net
    by pkulkarni
    1 Replies
    Last post by Michael Schreiber - DySoS
      • we are generating reports in excel format programatically in DOT NET....But It is taking too much of time for report generation....(10 mins for 300 records)... Then we transfered our data in HTMLtable formate and then we are opening the HTML file in excel...This process of report generation is very fast as compared to the previous method mentioned above.But the problem that we are facing is if
  • Message for display during macro execution
    by une
    3 Replies
    Last post by une
      • I have a macro that takes a long time to execute. While it is running I would like to put an object on screen to inform the user that the macro is running and they should just wait. Otherwise they may think something is wrong. It would also be good if this object had a button on it the user could click to end the macro if they run out of patience. I thought about a message box, but when it is disp
  • How could I count the last column in row 1?
    by lyp_sj
    5 Replies
    Last post by Duane in Japan
      • Hello, I'm new for VBA, so I'm wonderring how I can count the # of column in row 1. Thanks so much for help! B.regards/Yaping
  • 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
  • Is there any field event such as 'Entering' or 'Focus' for MS word form
    by rlinxu
    1 Replies
    Last post by Cringing Dragon
      • Hi, I am new in VB programming. I'm working on a MS word's form. I am trying to invoke a Address Checking program when cursor move into ADDRESS field. Is there any field event such as 'Entering' or 'Focus' I can use and "Exiting' event when move out the field Thanks in advance
  • 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
  • How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel?
    by Sajagesh
    8 Replies
    Last post by Sajagesh
      • How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel If the combo boxes are named using the cell reference on which these combo boxes are placed and linked. For example, a combo box, placed over the cell "G23", will be named as G23.
  • Different classes in one collection
    by wlwlz
    6 Replies
    Last post by Cringing Dragon
      • Hello Everyone, I just recently started to learn VBA so there are quite a few things I'm having trouble with. When I tried to put multiple classes in a collection and later use For Each <Class> to access them by each class, it would result in an error stating object type does not match. Just wondering is there a way to implement what I'm trying to do here in VBA Namely,