Microsoft ISV

Page 21




  • Topics
    Replies
    Last post
  • Using VBA macro to locate next free column on worksheet
    by rabbitoh
    14 Replies
    Last post by magicalclick
      • I need a macro that locates the next free column (i.e. has no data in cells) and then places the cursor in a cell on a designated row. Would like search to start from column B and to place the cursor on row 4 on the free column. <> My VBA code thus far: Function NewColNumber(Range1 As Range) As Integer Dim j As Integer For j = 1 To Range1.Columns.
  • 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
  • How can I see the stack trace from the .mdmp file?
    by Vedratna
    14 Replies
    Last post by Vedratna
      • hi, everbody we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i
  • MODI Port
    by riph
    4 Replies
    Last post by semsem2005
      • I have some questions: 1.- How to distribute MODI Port with my application 2.- Found MSM (module merge) 3.- How to install "Microsoft Document Imaging Writer Port", without CD office 4.- That files use the MODI 5.- The files .MDI is better of PDF ! Tks a lot,
  • Calculations in forms that update tables
    by knewbe
    2 Replies
    Last post by NWAprog
      • Keep in mind i had a VB class about 5 years ago. I created a database with access and i am trying to calculate cost based on units and cost per unit on the form i bult. But i want the calculation to be updated in a table righ now i have an expression but i doesnot update the table. I am trying to using an event procedure but its been so long and i cant remember exact syntax. Can i declare t
  • CRM 3.0 SDK Contact Merge
    by MattMasotti
    4 Replies
    Last post by MattMasotti
      • I'm using the following code, which is pretty much right out of the sdk documentation example: Dim target As New TargetMergeContact Dim mergeReq As New MergeRequest target.EntityId = contactCRM(Pri).contactid.Value mergeReq.SubordinateId = contactCRM(Sec).contactid.Value mergeReq.Target = target Dim merged As MergeResponse = CType (crm.Execute(mergeReq), MergeR
  • Inputbox used for different data types
    by Jonas.S
    0 Replies
    Last post by Jonas.S
      • Never mind I have fixed it. The misstake was that the first element in myX() is not myY(1) as I thought but myX(0). This since I not using Option Base 1. See red marked for solution.   Hi All, I want to use Inputbox for collecting range data for a plot. The thing is that I want to check if the first cell is numeric or text. If text I want to use that for naming the serie in the ch
  • 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
  • need vba code to read between two different xcel workbooks
    by wjulaxer13
    2 Replies
    Last post by wjulaxer13
      • i am writing VBA code to run behind an excel workbook. I found that I need info that is contained on another workbook altogether and would like to know how i can access a different workbook. I would guess a path/file name, worksheet name, and tab at the minimum but there must be more to it than that. I havent found the solution to it in my experiments. anyone able to help me
  • Hyperlinks.add in Word 2007 is BUGGY?
    by Bit-n-Pces
    1 Replies
    Last post by Cringing Dragon
      • I have some VBA code that writes a hyperlink into a Word document. The code has worked since Word 10 but now does not work in Word 12 (2007). I create a user type, typHyperlink and populate it with the variable text strings I want to use in the link and then insert the link into a selection range, like this: With myHyperlink strAddress = .hlAddress strScreenTip = .hlScreenTip strS
  • 'a.length' is null or not an object
    by jasminerose
    0 Replies
    Last post by jasminerose
      • Hi All, I wrote the following on the onsave event to have the Applyrule dialog to popup as soon as the save is clicked var oId = crmForm.ObjectId var msg = " http://10.10.10.2:5555/_grid/cmds/dlg_applyrule.aspx iObjType=3&iTotal=1&sIds ="+ oId window.open(msg); Dialog pops up but when I select a workflow process and click on ok nothing happens and I noticed that the on the Stat
  • Excel VBA - Worksheet_Change problem?
    by Tony Rosen
    4 Replies
    Last post by ConnollyG
      • Help please ... I have a SUB called "ValidateStopDate()" that I need run when Range("F2") changes.  In my Worksheet_Change sub, I have: Private Sub Worksheet_Change(ByVal Target As Range)     Dim KeyCells As Range     ' The variable KeyCells contains the cells that will     ' cause an alert when they are changed.     Set KeyCells =
  • Listbox scroll problem
    by DeathSurfer
    3 Replies
    Last post by Dan6845646+5414532
      • Duuuuudes: I have a problem with scrolling to the bottom of a listbox in excel '03. I'm using the listbox control in vba, not the excel forms control. Anyway, when I scroll to the bottom of the list, it won't let me see the last item in the list box. It will stop one short and will actually have a space below the scroll bar that looks like it could scroll down one more list item but won't.
  • wmi ebook
    by taral
    2 Replies
    Last post by Jay Vora
      • hi plz give me links for wmi free ebook thnx
  • Some questions about WER
    by Nikolai Bochkarev
    5 Replies
    Last post by Jason Hardester - MSFT
      • Hi! I'm integrated WER support in my Delphi 7 Application and now get some results 1) I'm register winqual account 2) Integrate WERAPI support in my application (Delphi program has own exception processing) 3) Map my .exe and upload xml file procedure TForm1.ApplicationEvents1Exception(Sender: TObject;E: Exception); var eventType : PWideChar; begin if
  • Storing a Scorecard Manager diagram in a database
    by karimi
    1 Replies
    Last post by MS ISV Buddy Team
      • Hi everybody, I want to use Microsoft Office Scorecard Manager for strategy Map but I'm not sure whether it satisfies my requirement. I want to draw a strategy map and store it in a database in a way that its attributes including parent-child relationship and the name of node are save in the database so that I be able to query of these information and connect them to the external attributes.
  • Business Scorecard Manager 2005 problems
    by Reed987
    2 Replies
    Last post by Reed987
      • I have recently begun working with Business Scorecard Manager 2005 to see how it integrates with my companies setup of MOSS 2007. I am having a tough time getting started and was hoping that someone could point me towards a tutorial or something discribing how to build a simple KPI/Scorecard. I've looked, but I've come up with nothing so far and I'd really like to get something up for my boss to l
  • Strange recoeded code for pasting device independent bitmap
    by Yaron Kohavi
    3 Replies
    Last post by Jon Peltier
      • Hi, When I record a macro which emulates the following menu selection: Edit, Paste Special, Device independent bitmap, I get the following code: Sub Macro2() ' ' Macro2 Macro ' Macro recorded t12/03/2007 by yaronk ' Selection.PasteAndFormat (wdPasteDefault) End Sub Sub PasteInde Where in fact, it seems as if the code should hav
  • how to get the hyperlink value from an excel sheet cell
    by Awsok
    10 Replies
    Last post by Duane in Japan
      • hi All I have an excel sheet that have some cells with text and under the text there is a hyperlink to another files to the network driver Does any one knows how to extact the value of the hyperlink (not the text value that how up). I tried many variations like =CONCATENATE("link ",T(HYPERLINK(A1))) but it didnt help !! Thanks for participating Aws
  • VBA Merge question
    by Janfry
    3 Replies
    Last post by Peter Mo.
      • Hi (my English is not very good but i'll try it). When I link the datasource to the document, appears a dialog to select the text encoding. The Document.Open method has a parameter to specify the Encoding, but MailMerge.OpenDataSource does not include it. Is there any way to not appear that dialog Thanks, Janfry
  • vlookup
    by Namrata Prashar
    14 Replies
    Last post by Namrata Prashar
      • Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata
  • How to create a menu & submenu ?
    by JL-65
    2 Replies
    Last post by Shlizar Axis
      • Hello, I¡¯m beginner on Access-VB. I try to create a menu and sub-menu programmatically. I can create a menu but not sub-menu. Could you help me Here my code. ------------------------------------------ Sub SubMenuCreation() Dim MyMenubar As CommandBar Dim NewMenu As CommandBarControl Dim MyNewMenu As CommandBarControl
  • Using VB in MS Access
    by elitts
    2 Replies
    Last post by Toblerone
      • Ok, I have no knowledge of VB. I am attempting to co-opt a bit of someone elses database. I am using 2 combo boxs in a form header to search for a specific record using 2 different fields. If the record exists than the fields in the detail section of the form are filled in. If it isn't located then nothing happens. One of the two fields is a key field with a numberic autonumber. This search works
  • Create Link to a Folder in the body of a Task
    by George Rickerson
    0 Replies
    Last post by George Rickerson
      • Hello - In Outlook, I can drag a folder into the body of a task, and Outlook creates a link to the folder in the task body. Then, anytime I open the task, I can then get to the folder by clicking on the link. How can I mimic this behavior in VBA I have tried just creating a string that is the folder's path and putting that in the body of the task, but it is just a text string and is
  • How do I call for all installed printers....
    by MyLady
    5 Replies
    Last post by magicalclick
      • Hey, How do I, with vba code, call for all installed printers in my computer and then display them in a ListBox Best Regards Cathrine