Ετικέτες

Τρίτη, 15 Μαρτίου 2011

Μια πολύ καλή Σελίδα για VBA στο EXCEL

Μια πολύ καλή Σελίδα για VBA ,EXCEL

Amplify’d from www.rondebruin.nl
Ron's Excel Tips
Published articles



My articles on the Microsoft Office Developer
Center (MSDN)



Customizing Context Menus in All Versions of Microsoft Excel
New

Working
with the Compatibility Checker in Excel 2007 and Excel 2010



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)



Office Visual How To

Merging
Data from Multiple Workbooks into a Summary Workbook in Excel
New



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 Excel

Excel Add-ins page

Example Code for sending
mail from Excel
Tip

Mail code examples for Lotus Notes



Pages only for Excel 2007-2010

Create and Mail PDF files
with Excel 2007/2010


Use VBA SaveAs in Excel
2007-2010


Compatibility
Checker in Excel 2007-2010


Sheet Direction in Excel 2007-2010

Filtering by the Active Cell's Value, Font
Color or Fill Color in Excel 2007-2010


Disable Excel 2003 Menu Accelerators keys
in Excel 2007-2010


Table Tools Add-in for Excel 2007-2010

VBA code examples for a List or Table in Excel
2003-2010


Help: Different Excel file formats and
Excel versions


Where can I find the
menu commands in Excel 2007


Macros are disabled when you open password
protected workbooks in 2007


Shapes and VBA code in Excel 2007

Copy sheet security dialog
in Excel 2007


Reverse compatibility problem of the old ATP functions
in Excel 2007




Excel 2007-2010 Ribbon and QAT pages

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


Load different
RibbonX when opening file in Excel 2007 or 2010


Customize
Contextual tabs in Excel 2007 and Excel 2010
 
New

How do I change Backstage(File) view in Excel
2010


Menu for favorite macros in
Excel 2007-2010 (for all workbooks)


Menu for favorite macros in
Excel 2007-2010 (for one workbook)


Add buttons to the QAT and customize the images
of the buttons


Images on Custom Ribbon controls Updated

Menu in the Ribbon with different languages

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


Dealing with Ribbons and Menus - Avoiding
Two Versions


Customizing Context Menus in Microsoft Excel



Context and Popup menus and Application.Run

Customizing Context Menus in Microsoft Excel

Creating a PopUp Menu that
is working in every Excel version
New

How do I use
Application.Run in Excel
New





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 a List or Table in Excel
2003-2010


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 in Excel 97-2003


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

Read and post in
Forums with the Community Forums NNTP Bridge


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


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


Read more at www.rondebruin.nl
 

Δεν υπάρχουν σχόλια:

Δημοσίευση σχολίου