VBA

Get flash to fully experience Pearltrees

http://msdn.microsoft.com/en-us/library/office/gg508921.aspx

Exporting a Table to a Word Document

Published: July 16, 2012 This example takes the table named “Table1” on Sheet 1 and copies it into an existing Word document named “Quarter Report” at the bookmarked location named “Report”. Sample code provided by: Dennis Wallentin, VSTO & .NET & Excel | About the Contributor Sub Export_Table_Word() 'Name of the existing Word doc.

WinParrot Official Website

Tutorial del Control ListView

http://www.recursosvisualbasic.com.ar/htm/tutoriales/control-listview.htm

Sección de tutoriales y manuales vb Volver al índice Esta guía describe el uso de algunas de las principales características del control ListView de Visual basic Contenido : 1 - Introducción Si observamos por ejemplo el explorador de windows podemos ver que en la parte izquierda de la pantalla tenemos una vista en forma de árbol con todos los directorios del sistema y en el costado derecho podemos visualizar el contenido seleccionado, es decir las carpetas, sub carpetas y archivos.

The information, illustrations and code contained in my "Microsoft Word Tips" are provided free and without risk or obligation. However, the work is mine. If you use it for commercial purposes or benefit from my efforts through income earned or time saved then a donation, however small, will help to ensure the continued availability of this resource. If you would like to donate, please use the appropriate donate button to access PayPal. Thank you! T his Microsoft Word Help & Microsoft Word Tips page will show you how to use VBA to insert text "at" or "in" a bookmark and the advantages of using the "at" method.

http://gregmaxey.mvps.org/word_tip_pages/insert_text_at_or_in_bookmark.html

Insert Text "At" or "In" a Bookmark

Links

This list is not exhaustive by any means, but it includes many of the sites in my Favorites list. Feel free to recommend an addition to the list. Excel sites MrExcel One of the biggest Excel sites on the Web.

Combinar personalizaciones de VBA y de nivel de documento

Creación de Informes | Daniel Garzon

Abrir el Administrador de IIS (IIS 7)

Excel's color palette contains 56 colors, all of which can be accessed and most of which can be replaced using ExcelWriter (v6 or later). This post describes the layout of the palette and enumerate the default palette colors. This content is most pertinent to the Excel 2003 color palette, which only has 56 colors. In Excel 2007 and later, workbooks can support millions of colors, but there is still an underlying workbook palette that has 56 colors.

Excel's color palette explained

VBA Tips: A Pop-up Calendar for Excel

Suitable for: Excel 2007, 2010 Click here for Excel 97, 2000, 2003 One of the biggest problems in maintaining "good" data is the entry of dates. People seem to get confused about entering dates. Should they enter dd/mm/yy or mm/dd/yy?

There are instances when one wants to figure out which elements of a set of numbers (amounts) total to a target value. One instance where this may be necessary is for a company that receives a check for outstanding accounts receivable (A/R) bills but doesn't have matching documentation indicating what bills are being paid. Excel template using Solver

http://www.tushar-mehta.com/excel/templates/match_values/index.html#VBA_multiple_combinations

Find a set of amounts that match a target value

How To Sum Tree Structure In Excel Freeware Downloads: How To Recover VBA Password Downloader, How To Read SQL Database, How To View SQL Database

ACCESS

March 3, 2009, 8:38 AM PST Takeaway: Access 2007 lets you create pivot tables without building a query. See how this feature can simplify your data analysis. With Access 2007, you no longer need to build a query to create a pivot table. You can create one straight from a table by using PivotTable view.

Instead of queries, use the Access 2007 PivotTable view

Using PIVOT and UNPIVOT

A common scenario where PIVOT can be useful is when you want to generate cross-tabulation reports to summarize data. For example, suppose you want to query the PurchaseOrderHeader table in the AdventureWorks2008R2 sample database to determine the number of purchase orders placed by certain employees. The following query provides this report, ordered by vendor. USE AdventureWorks2008R2; GO SELECT VendorID, [250] AS Emp1, [251] AS Emp2, [256] AS Emp3, [257] AS Emp4, [260] AS Emp5 FROM (SELECT PurchaseOrderID, EmployeeID, VendorID FROM Purchasing.PurchaseOrderHeader) p PIVOT ( COUNT (PurchaseOrderID) FOR EmployeeID IN ( [250], [251], [256], [257], [260] ) ) AS pvt ORDER BY pvt.VendorID; Here is a partial result set. VendorID Emp1 Emp2 Emp3 Emp4 Emp5

http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

Our August 2002 Challenge is inspired by a recent posting on the MS boards. Thanks to Harlan, Tim, and Tushar for a lively discussion around this problem. Here is the specific problem. An accounts receivable department receives a check from a customer for $4,556.92. Upon looking in the accounting system, there are 54 unpaid invoices, ranging from $77.74 to $5,465.45.

Name the MrExcel Logo - Answer to Challenge of the Month

Roger Myerson | Simtools and Formlist add-ins for Excel

About SIMTOOLS and FORMLIST Simtools.xla and Formlist.xla are add-ins for Microsoft Excel (version 5 and later). Simtools adds statistical functions and procedures for doing Monte Carlo simulation and risk analysis in spreadsheets. Formlist is a simple auditing tool that adds procedures for displaying the formulas of any selected range.

VBA and Macros: Microsoft Excel Copyright © 2010 by Que Publishing All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein.

VBA.and.Macros.microsoft.excel

En este artículo se incluye una introducción rápida de Microsoft Excel 2010 y se proporcionan vínculos a artículos más detallados sobre determinadas tareas y características. Si está familiarizado con Excel y desea obtener información sobre los cambios de la última versión, pruebe con los recursos de la tabla siguiente. Si nunca usó Excel o si se considera un usuario inexperto, puede que la siguiente información sea de utilidad.