vba

Welcome to the 'vba' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'vba'.

Latest blogosphere posts tagged “vba”

• Simple Excel Vba Combine Scrip

  
  Get a Freelance Job — Authority: 182
  I have a very simple VBA code I need I just don’t know how to do it so posting here; I have several sheets in a workbook with multi-column records. Many of these records are partially identical and need to be merged. Generally this is because one record has values in some fields and the other has values in others. ...
  6 hours ago

• RE Querying with VBA

  
  Blackbaud User Society - Forum — Authority: 139
  Hi, Im trying to run a query in code, so I can get the Constituent ID values to use later in my script. Acquiring data from a query is not a problem. The thing is that I want the query to search for Constituents with "xxxxx" phone number where the phone number is actually a variable from earlier in my code (phone ...
  1 day ago

• Accessing an Access DB from Outlook via VBA

  
  IT answers — Authority: 457
  New Question Created by Camastanta
  1 day ago

• Taking Advantage Of Microsoft Excel VBA In-house Tuition

  
  Blog Your Site — Authority: 162
  Are your staff getting the most out of Microsoft Office Excel 2007? Microsoft Office Excel is a spreadsheet-application that was started back in 1987 by Microsoft. This program has all sorts of features such as graphing tools, pivot tables and calculations. In 1988, Excel started out selling the competition and began ...
  2 days ago

• Learning About Microsoft Excel 2007 VBA On-site Training

  
  The RVC Blog — Authority: 156
  Are your staff getting the most out of Microsoft Office Excel ? Microsoft Excel was a spreadsheet-application program that was started back in 1987. In 1988, sales for Excel began to be better than the competition and Excel began getting receiving software updates roughly every 2 years. Since 1993, Excel has been ...
  5 days ago

• Excel VBA: Show a Message to Users

  
  Contextures Blog — Authority: 414
  Unfortunately, no one has found a way to zap users with a mild shock from the keyboard, so we have to rely on messages to help people do the right things in Excel. You can create messages without Excel VBA. For example, you can add a comment to a cell , or use a data validation input message . To keep ...
  6 days ago

• VBA MP3 Player

  
  Programmers Heaven Forums RSS Feed — Authority: 160
  This is a sample of exploring macro Ms. Excel (Visual Basic of Application - VBA) to create a MP3 Player that running on Ms. Excel application. Please check or take a look the program by download it from http://wl.filegenie.com/~Rusdi/VBA-MP3-Player.xls Set security level of macro Ms. Excel to Medium before running ...
  6 days ago

• ACCC Okays Virgin-Delta Joint Venture Deal

  
  My Share Trading — Authority: 122
  Australian Competition and Consumer Commission gave Virgin Blue ( VBA ) the approval to go for operating the Pacific route through a joint venture with US based Airline giant Delta Airways. The decision came from ACCC after the plan got approval from the US Department of Transportation last month allowing the two ...
  6 days ago

• Delete and Replace All Embedded Charts in Workbook

  
  Programmers Heaven Forums RSS Feed — Authority: 160
  I have written a VBA code that generates several charts but what Id like to do is that each time I run the program the new chart comes and overwrites the old one, so I will always have the most accurate chart in my workbook. Also, When youll see my code, I have included in every Phase what I thought to be my solution ...
  6 days ago

• List VBA Procedures by VBA Module and VB Procedure

  
  PTS Blog — Authority: 413
  Mathias Brandewinder of Clear Lines Blog tweeted up Displaying a List of All VBA Procedures in an Excel 2007 Workbook from the Ribbon , an article by Microsoft’s Frank Rice on the MSDN web site, which showed a VBA procedure for listing all of the VBA procedures in a VB project. Interesting procedure, could be ...
  1 week ago

• Help using the API to run an export

  
  Blackbaud User Society - Forum — Authority: 139
  Hello all, I am new to the API and Raisers Edge in general. I am trying to run an export using the export but I have run into a brick wall. If there is another way to do this I would very much like to hear it. My Code: Code: BBREAPI7.IBBSessionContext se;             BBInterfaces.IBBSessionContext sc; ...
  1 week ago

• Custom Appointment Macro locks rest of Outlook when run

  
  Programmers Heaven Forums RSS Feed — Authority: 160
  Ive created a basic macro and assigned it to a toolbar button. The macro opens the new calendar appointment window with a default template (I know there are other ways to do this via personal and organizational templates etc. but for a handful of users with limited access rights this is the way we want to go). The ...
  1 week ago

• What You Need To Know About Microsoft Excel 2007 VBA Training Classes

  
  The RVC Blog — Authority: 156
  With Microsoft Office Excel 2007 VBA you can write macros which will automate all the operations you usually perform in Excel. Do you use Microsoft Excel VBA on a daily basis? Or are you new to the program and need more training on it? No matter which one you are trying to achieve there are many types of training in ...
  1 week ago

• How to code the grand children?

  
  Programmers Heaven Forums RSS Feed — Authority: 160
  Suppose I create a Form in Run time say Form1, and add a control say cmd1. If the user clicks the cmd1 then we have to close the Form but how to attach code to that control, exactly an event procedure for that cmd1. I want to understand the fundamentals. Thanks in advance.
  1 week ago

• How to code the grand children?

  
  Programmers Heaven Forums RSS Feed — Authority: 160
  Suppose I create a Form in Run time say Form1, and add a control say cmd1. If the user clicks the cmd1 then we have to close the Form but how to attach code to that control, exactly an event procedure for that cmd1. I want to understand the fundamentals. Thanks in advance.
  1 week ago

• VBAC scare tactics (9): You have *how many* scars on your uterus?

  
  Birthing Beautiful Ideas — Authority: 116
  Many women who want to have a vaginal birth after cesarean (or VBAC, pronounced “vee-back”) in the U.S. have faced some sort of opposition from their care providers when they have expressed their desire to VBAC.  Oftentimes, this opposition comes in the form of ” VBAC scare tactics.” The (outrageous) ...
  1 week ago

• Display Word documents full path in title bar

  
  Microsoft Office — Authority: 124
  When you open a new document, Word displays a generic name in the title bar– documentx . Once you give the document a meaningful name (by saving it), Word updates the name in the title bar. However, in both cases, Word displays only the file name. It won’t display the full path to the document. ...
  1 week ago

• Preventing auto_open and Workbook_Open events from running

  
  Daily Dose of Excel — Authority: 460
  As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. With Excel 97 to 2003, this was simple: hold the shift key when you click “Enable macros”. With Excel 2007 and ...
  1 week ago

• Robust VBA Save-As Technique

  
  PTS Blog — Authority: 413
  One of the most important things a VBA procedure can do is save a file, especially a file that’s been substantially modified by that procedure. This functionality is even better if the user is given the opportunity to specify a path and file name.  You can simply pop up Excel’s own Save As dialog: ...
  1 week ago

• Soap Ovh In Excel Vba

  
  Get a Freelance Job — Authority: 182
  Hi, I would like to convert a script php5 in VBA excel. My situation: I have a formular in html and it is using to send an email. When I click on the bouton “send”, the script send.php5 run. send.php5: $nic=”xx123456-ovh”; $pass=”ovh123456″; $sms_compte=”sms-xx123456-1″; $from=”+336666666″; ...
  1 week ago

Comments about vba