Microsoft ISV

Page 25




  • Topics
    Replies
    Last post
  • Using Excel files in MS Works
    by missypam
    1 Replies
    Last post by Andy Pope
      • Had Office and XP on my previous computer and created several Excel files I want/need to keep New computer has Vista and MS WORKS installed - will I have a problem with transferring the Excel files to new computer If so, how do I remedy
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • error with wscript.shell error 80070483
    by rhXX
    0 Replies
    Last post by rhXX
      • hi, i am trying to run a vb script from a VBA module in excel. fn = "test.vbs Set wshShell = CreateObject("Wscript.Shell") wshShell.Run (fn) in the line wshShell.Run (fn) i obtain an error error 80070483 method Run of object IWshShell3 failed it is the first time i do this, so i am not shure if i need to have done something before, some references in windows extension .vbs is no
  • 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
  • Adding Menu to Microsoft project 2007 using VBA
    by Sacgupta
    0 Replies
    Last post by Sacgupta
      • How can I add a custom menu using VBA code. There are some changes happened in from Microsoft Project 2003 to Microsoft Project 2007. How can I add custom menu to microsoft project 2007 and make it work to invoke appropriate code. Are there any whitepaper which talks about the changes in the coding from Microsoft project 2003 to 2007. I am new to this area of coding with little knowl
  • compile error: invalid quaifier
    by CarlaCruz
    3 Replies
    Last post by CarlaCruz
      • Hi! I'm a portuguese school teacher that uses vb 6.0. The error mentioned occurs here **: Public Sub introduz() i = 0 Do While i <= 20 VF.Nr(i) = Val(InputBox("Introduza o numero de cliente", "Numero de cliente")) ** VF.NomeCliente(i) = InputBox("Introduza o nome do cliente", "Nome do cliente") If VF.NomeCliente(i) = ("XYZ") Then
  • Collection Item: Parent / NextItem
    by Paul_NL
    1 Replies
    Last post by Andy Pope
      • Hi, I am struggling with classes. This is what I want to do, in VBA (test it in Excel please): I want to add a property/function to my class, named NextItem and PreviousItem. These return the next and previous items in the collection. I have several separate collections where I keep my items in. So if I want to determine the next and previous item, I need to figure out in which collection the item
  • VBA Language Definition
    by RyanH106
    2 Replies
    Last post by RyanH106
      • Hi, just a quick question Does there exist anywhere a formal definition of the VBA language It would be really useful for my dissertation as i am writing a program that interprets macros so could do with something that would tell me, for example all the different ways that variables can be defined, or all the different types of statement that can be used etc. Any advice is much appreciat
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • VBA 6.5 New Version?
    by GTVic
    2 Replies
    Last post by GTVic
      • I have loaded Office 2007 and the VBA about screen states version 6.5. Is there any documentation on recent changes to the VBA environment An older product which includes the VBA environment is not able to launch any VBA macros with Office 2007 installed. The upgrade to VBA 6.5 may be the problem and I would like to find some detailed information on new releases. Thank you, Greg
  • Updating column totals in sub forms
    by ProfSchiavo
    0 Replies
    Last post by ProfSchiavo
      • This has to be simpler than I'm making it! Trying to maintain column ototals ni SubForm, and update them to the MainForm. Typical Northwind-type Orders-&-Details relationship: I extend row totals in the OrderDetails subform; and show OrderTotal (column total) in the SubForm's FormFooter. So far, so good. But when I change a quantity or price in the subform, I'd expect the subtotal to change au
  • AutoExec will not execute properly
    by J&amp;#252;rgen1234
    4 Replies
    Last post by Jurgen1234
      • Hello there I have an .dot file in the Word 2003 start-folder. When opening word, the file is read. The autoexec-macro should make a new entry with a number of commands and subcommands in the standard menubar. On about 300 PC's this works fine. On a few ones only part of the commands appear. All PC's run W2000 and Office 2003. Any idea regards Jurgen
  • 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
  • Fill word document with fields from Access form programmatically
    by RhysDavies
    2 Replies
    Last post by RhysDavies
      • Hi - i have a form called 'formpo' that allows users to enter information that we use for purchase orders such as date, order value, supplier name, purchase description, etc etc. when the user has filled in the information on the form i would like them to be able to click a button on the form screen that will take the values from the form and insert them into a specific word document, and have the
  • Projects, objects & modules
    by une
    14 Replies
    Last post by une
      • I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named
  • VBA read a value and not a formula
    by Pompoire
    3 Replies
    Last post by Peter Mo.
      • Dear All, I have a question, I want to sum some values if a reference is equal to a date that I implemented in a cell that I defined as name (defined as string) name changes in a loop. I used the following formula ActiveCell.FormulaR1C1 = "=SUMIF(R[-2]C10:R[-2]C100 ,"" = name"", RC[7]:RC[84])" unfortunatelly it does not take the VALUE of the nam
  • ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista
    by Claus Brod
    12 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where
  • CurrentRegion Property to Specify SourceData in PivotCache Method
    by jbrcks
    3 Replies
    Last post by Jon Peltier
      • I'm fairly new to writing VBA macros to create pivot tables in Excel, and I could use some help. I would like the macro I am writing to be able to use the Currentregion property in order to specify the SourceData for the PivotCache method, where the source data is located on a sheet named "macro". Any feedback warmly appreciated.
  • 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.
  • Right-click menu icon
    by RiskyBusiness
    2 Replies
    Last post by mathoc
      • Hi there, Can you tell me how to add an icon next to a custom right-click menu item Like the little scissors next to the "Cut" item, I would like to place an image next to my custom menu item. Any help would be great. Thanks.
  • 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
  • Search (e.g. Windows Desktop Search) for specific words in VBA code
    by Morten Hvidberg-Knudsen
    0 Replies
    Last post by Morten Hvidberg-Knudsen
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • Cut A Variable Row from 1 Sheet and Paste to the End of Another Sheet with a condition to meet
    by AlvinB
    0 Replies
    Last post by AlvinB
      • I wanted to Cut rows that has a status of "High" from sheet B and paste it to the end of sheet A. Sheet A and B will be ever growing list of items. Here's the code that I would like to share. I'm sure a lot more people who would like to create a VBA for Action Database will require this. Sub CopyHigh() Dim HighLastRow, iLastRow As Integer HighLastRow = Worksheets("A").Cells(Rows.Count,
  • Now Button
    by DinnerPlates
    1 Replies
    Last post by sjoo
      • Hi I'm new to coding macros and am wondering if anyone knows how I can create a button that jumps to today's date on a spreadsheet I have a long column of different dates and would like to make it easier for anyone who accesses the worksheet to go straight to today's date... I've been trying to use several combinations of the code "Range(Now).Select" but have yet to succeed..