Excel VBA Code & Tips

[TranThanhPhong]

Ron de Bruin (Cập nhật đến 27-April-2010)

Tải và đóng gói site chỉ dẫn về lập trình Excel của Ron de Bruin cho các bạn đọc mấy ngày lễ !

Ron's Excel Tips
Ron de Bruin (last updated 27-April-2010)
http://www.rondebruin.nl/

Kích thước 16433KB, tải và đóng gói ngày 29/04/2010

TTP.

Published articles

My articles on the Microsoft Office Developer Center (MSDN)
Using VBA in Excel to Send Workbooks and Ranges through E-Mail with Outlook (Part 1 of 2)
Using VBA in Excel to Send Workbooks and Ranges through E-Mail with Outlook (Part 2 of 2)
Creating and Sending PDF Files from Excel 2007 and Excel 2010 Working with Excel Workbooks and Worksheets in E-Mail
Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 1 of 2)
Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 2 of 2)
Creating Custom Ribbon Galleries in Excel 2007
Working with Lists and Tables: VBA Samples (Part 1 of 2)
Working with Lists and Tables: VBA Samples (Part 2 of 2)
Filtering by the Active Cell's Value, Font Color, or Fill Color in Excel 2007
Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel
Merging Data from Multiple Workbooks into a Summary Workbook in Excel
Implementing Week-Numbering Systems and Date/Time Representations in Excel
Different Ways to Take Advantage of the E-mail Features of Excel (Excel 97-2003)

My articles on Microsoft Office Online
Aanpassen van het Lint in Excel 2007 (Dutch)
Weeknummers berekenen in Excel (Dutch)


My Excel tips

Excel Add-ins and code for Mailing from ExcelExcel Add-ins page
Example Code for sending mail from Excel TIP

Excel 2007
Where can I find the menu commands in Excel 2007
Create and Mail PDF files with Excel 2007/2010
Use VBA SaveAs and CheckCompatibility in Excel 2007-2010
Copy sheet security dialog in Excel 2007
Sheet Direction in Excel 2007
Reverse compatibility problem of the old ATP functions
Macros are disabled when you open password protected workbooks
Shapes and VBA code in Excel 2007
Filtering by the Active Cell's Value, Font Color or Fill Color in Excel 2007
Help: Different Excel file formats and Excel versions
Disable Excel 2003 Menu Accelerators keys in Excel 2007
Table Tools Add-in for Excel 2007
VBA code examples for Tables in Excel 2007 or a List in Excel 2003

Excel 2010 (Beta) New
Load different RibbonX when opening file in Excel 2007 or 2010
Download to find the names of the Excel 2010 ControlIDs (819 kb)
Backstage view in Excel 2010

Excel 2007 Ribbon and QAT pages
Menu for favorite macros in Excel 2007 (for all workbooks)
Menu for favorite macros in Excel 2007 (for one workbook)
Change the Ribbon in Excel 2007 or Excel 2010
Change built-in groups in the Ribbon
Add missing built-in commands to the QAT or Ribbon
Add buttons to the QAT and customize the images of the buttons
Menu in the ribbon with different languages
Dealing with Ribbons and Menus - Avoiding Two Versions
Images on custom Ribbon controls
Galleries in the Ribbon
Hide or Display Ribbon Tab/Group/Control with getVisible
Where is my button that I add to the QAT of my workbook

Copy/Paste/Merge examples
Copy to a database sheet on the next empty row
Merge cells from all or some worksheets into one Master worksheet
Create a summary worksheet from all worksheets (formulas with VBA)
Create a link to or Sum a cell in all worksheets (worksheet functions)
Merge data from all workbooks in a folder (1)
Merge data from all workbooks in a folder (2)
Merge data from all workbooks in a folder: Add-in
Create a summary worksheet from different workbooks (formulas with VBA)
Merge data from all workbooks in a folder to a txt file
Copy every TXT or CSV file in a new worksheet of a newly created workbook
Merge all CSV or TXT files in a folder
Copy a range from closed workbooks (ADO)
Copy a range from closed workbook (Local, Network and on the internet)
Copy data from an Access database into Excel with ADO
Change cells or range in all workbooks in a folder
Copy records with the same value in a column to a new sheet or workbook
VBA code examples for Tables in Excel 2007 or a List in Excel 2003
Create a workbook from every worksheet in your workbook
Create separate sheet for each horizontal PageBreak
Copy, Move and Delete files and folders
How do I create/use a sheet template

Delete/Hide/Disable examples
Delete row if a specific value exist
Delete or Hide Objects/Controls on a worksheet
Disable command bars and controls
SpecialCells limit problem
Disable key or key combination or run a macro if you use it

Zip (compress) ActiveWorkbook, Folder, File or Files with VBA code
7-zip : Zip Activeworkbook, Folder, File or Files(VBA)
7-zip : Unzip a zip file (VBA)
Zip file or files with the default Windows zip program (VBA)
Unzip zip file or files with the default Windows zip program(VBA)
WinZip : Zip Activeworkbook, Folder, File or Files (VBA)
WinZip : Unzip a zip file(VBA)

Weeknumber/Dates
Use the Calendar control to fill in dates
Week numbers
ISO Date Representatation and Week Numbering

Help information
Help Context IDs for Excel 2000, 2002, 2003 and 2007
Where do I paste the code that I want to use in my workbook
How do I create a PERSONAL.XLS(B) or Add-in

Other pages
International Excel Issues New
Print tips for Excel
Test if Folder, File or Sheet exists or File is open
Find last row, column or last cell
Change formulas to values
Find value in Range, Sheet or Sheets with VBA
Cleaning "Dirty" Data
Lotus Transition Formula Evaluation Errors
Analysis ToolPak Translator 7.0