in
All Tags » VBA » office (RSS)

Browse by Tags

  • Replace special characters in VBA

    Hi, I'm writing a bit of code in VBA to convert a table into excel into an HTML formatted table. It's working fine except I need it to pick up certain special characters and replace them with their equivalent HTML notation. The one I'm having trouble with at the moment is the Omega sign....
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • Saving settings on the vba forms

    Dear all, In many cases, I have to do some settings (e.g. text size, starting number) in the form before execution the programme. However, that would be very tiring if I need to redo the same setting wheneven I restart the form in different documents. Is it possible to save the setting in the memory...
    Posted to Microsoft Office (Forum) by microsoft on 05-09-2010

  • In Access 2007 VBA, how would I use ranges/choices in conditions such as If...Then?

    If intVar could possible be an integer 1,2,3...10, how could I check for that in an If...Then structure. IOW, is it possible to do something like this: If intVar = [1,2,3] Then blah Or If intVar = [3-5] Then blah With strings? If strVar = ["X","Y","Z"] Then blah Or If strVar...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-03-2010

  • Reference to Selected Chart Series in Excel VSTO/VBA

    Hi, I have an Excel VSTO addin (VS 2008, VSTO 3, Office 2007, .NET 3.5). I want to perform an action on the selected chart series when a user clicks a button on my add-in ribbon tab. Is there a way to reference the selected series of the selected chart (if one is selected) through the PIA? I know that...
    Posted to VSTO (Forum) by microsoft on 05-02-2010

  • Access backend Excel frontend recordset query question

    I'm creating an application in Excel that uses Access as a backend. The end user's do not have Access licenses so the application has to be in Excel. The creation of the spreadsheets is based on recordsets created from the Access backend. Here's the question: Due to the number of spreadsheets...
    Posted to Excel (Forum) by microsoft on 04-30-2010

  • Copy PowerPoint 2003 slide master between presentations using VB or VBA

    Hi, Is there a way in VB.NET (using Office 2003 PIA) or in VBA to copy slide and title masters from one PowerPoint 2003 template to another? Pete
    Posted to Powerpoint (Forum) by microsoft on 04-29-2010

  • pass a listbox by reference in VBA

    Hi, I have a form with several list boxes on it. I want to be able to add items to the listbox provided they are not already in there. I have written a subrountine that takes a string and a listbox as its inputs and adds the string to the listbox if it is not already there. The problem I am having is...
    Posted to Visual Interdev (Forum) by microsoft on 04-04-2010

  • Setting references in a new Access 2003 database using VBA

    Hello, I'm trying to set the references in a new Access 2003 using VBA. I'm a kind of copying the references from an existing db to the new one The code is executed but no references are added in the new database. I'm using this code Can someone help me out with this? Code Snippet: 1: 2:...
    Posted to Access (Forum) by microsoft on 02-12-2010

  • Special Values in VBA

    Does VBA support the concepts of Negative Infinity, Positive Infinity, NaN, and Epsilon for its floating point data types? If not, could you suggest a good way of emulating them?
    Posted to Excel (Forum) by microsoft on 01-17-2010

  • Word Label Mail Merge Automation

    Hi MS Word VBA/VSTO experts, Is there a Word VBA command or a method in the Word 2007 Interop that does exactly the same as clicking the Update Labels button on the Mailings ribbon tab? Thanks, Pete
    Posted to VSTO (Forum) by microsoft on 12-04-2009
Page 1 of 4 (33 items) 1 2 3 4 Next >