Μια πολύ καλή Σελίδα για 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

 

See this Amp at http://amplify.com/u/bvifd