in
All Tags » VBA (RSS)

Browse by Tags

  • VBA constants generating compile error in Windows 7

    Experts: I have programmed an Excel 2007 Add-in using VBA. It uses automation to control PowerPoint. I wrote it on a Windows XP machine. Yesterday I tested it on a Windows 7 machine which also has Office 2007 installed. Most of my macros work, but I'm getting a bunch of "Compile Error. Cannot...
    Posted to Automation (Forum) by microsoft on 05-24-2010

  • Access DB interface: VBA or VB2008?

    I have a decent sized database running off vba in Access 2000 (about 4000-6000 lines of code). I'm about to start writing another one which will eventually reach about the same size. My predecessor wrote most of the first database and while I think he did a great job, I bet upgrading to VB 2008 would...
    Posted to Access (Forum) by microsoft on 05-24-2010

  • VBA lookup function to return multiple values

    There was a post with a solution at the following link http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_24237627.html?sfQueryTermInfo=1+from+lookup+multipl+return+valu+vba but I cannot get that to work. Can someone else verify that this code works? I always...
    Posted to Excel (Forum) by microsoft on 05-24-2010

  • Creating a DSN in VBA

    Is there a way to create an ODBC DSN in Access VBA code?
    Posted to Access (Forum) by microsoft on 05-24-2010

  • Sub queries within grouped queries & constructing with VBA

    All, I am looking for some help with a set of queries I am trying to build using VB in access. The part I'm having trouble with is controlling a query within a query and how it relates to the main query. So I have this main query: 1: 2: 3: 4: SELECT tbl_BBCs.AFState, Count(tbl_Outstanding.OutstandingBalance...
    Posted to Queries (SQL) (Forum) by microsoft on 05-24-2010

  • Disable CheckBox on UserForm in Excel depending on selections

    Hi Experts! I have a Userform in Excel (2007) with several check-boxes on it. For example, there are 2 categories, each with 5 check-boxes under it. The user needs to check one from checkbox 1-5 (category 1) and one from checkbox 6-10. Upon selection from any of the checkboxes 1-5, say number 2, then...
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • bugs within subs

    Can anyone help me to fix the bugs through these subs? The sub CountSales asks the user for a state and a sales rep, and then count the number of sales by this sales rep in this state. The TotalSales1 sub asks the user for a date. Then the total of all sales in all states up to(and including) this date...
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • Redim array

    Hi I hope you can help. I'm also hoping that this will be quite simple....:-) I have a macro which stores data into an array. The array is (?,8). For various reasons, I don't want to count the potential number of entries before dimensioning the array, so I need to store the data into it and then...
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • How to use VBA to uninstall a program with msiexec.exe

    I am trying to imitate the uninstalling of a program with VBA to save the user doing it. The program is a plugin so it only has an unistall shortcut with the following target. It is the google earth plugin. "C:\WINNT\system32\msiexec.exe /x {2862C000-331E-11DF-89BF-005056806466} FEEDBACK=1"...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-23-2010

  • Access Tables and Queries

    Howdy, I have two access tables. The first has customer data (names, addresses, creditcards, etc). The second is a menu of items that may be shipped to the customers, based upon what the customer prefers. For example, lets say that the menu items are beer (everyone's favorite) and that out of fourteen...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-23-2010
Page 4 of 298 (2977 items) « First ... < Previous 2 3 4 5 6 Next > ... Last »