Welcome To Snipplr


Everyone's Recent Snippets Tagged excel



« Prev 1 2 3 4
  1. FAV

    Read data from txt files

    Read data from TXT files to import them in Excel environment
    Visual Basic 19 views posted 2 years ago by buglilorenzo
  2. FAV

    Excel (VBA) worksheet password cracker (Ver 2010 & below)

    If you've forgotten a password to an Excel workbook that was created in version 2010 or older. See URL for more details.
    Visual Basic 2 views posted 3 years ago by cueballrawn
  3. FAV

    Excel (VBA) drop down list multiple values in single cell

    Selecting different values from a data validation drop down list will populate the same cell, i.e. it will create a concatenating list separated by commas. Amend the "If Target.Column" values to set the columns this applies to.
    Visual Basic 3 views posted 3 years ago by cueballrawn
  4. FAV

    Excel (VBA) Custom right-click menu to launch macros

    Create a custom right-click menu that will list and launch all macros in the DemonstationMacros module. Copy and past the code into the relevant object or module.
    Visual Basic 2 views posted 3 years ago by cueballrawn
  5. FAV

    How to Set Line Spacing of a Paragraph in an Excel Shape or Textbox inside .NET Apps

    This technical tip shows how to Set Line Spacing of the Paragraph in a Shape or Textbox in .NET applications. You can set the line space of the paragraph, its space before and space after using the TextParagraph.LineSpace, TextParagraph.SpaceBefore a...
    C# 1 views posted 3 years ago by sherazam
  6. FAV

    Excel (VBA) list all filenames in a directory

    Lists all filenames in a directory if you need them for formulae or add into VBA.
    Visual Basic 2 views posted 3 years ago by cueballrawn
  7. FAV

    Excel (VBA) Hash string using SHA1 - pseudonymisation

    Create a bespoke Excel function that allows you to hash (anonnymise / pseudonymise) strings such as unique identifiers. Once you've inserted the VBA, use the function "=BASE64SHA1(cellreference)" to generate the hash.
    Visual Basic 1 views posted 3 years ago by cueballrawn
  8. FAV

    Access (VBA) Open and run macro from an Excel workbook

    This code allows you to open an Excel workbook from an Access database and run macros within the target workbook. This could be used to format / clean data prior to import for example.
    Visual Basic 3 views posted 3 years ago by cueballrawn
  9. FAV

    Excel (VBA) hide specific worksheets

    Hide specific worksheets in a workbook that contain a prefix. This example uses "Admin_", although this can be changed easily.
    Visual Basic 1 views posted 3 years ago by cueballrawn
  10. FAV

    Excel (VBA) unhide all worksheets

    VBA to unhide all worksheets in an Excel workbook.
    Visual Basic 2 views posted 3 years ago by cueballrawn
  11. FAV

    Clean metadata from documents created by a particular author

    This source code uses public classes and interfaces exposed by GroupDocs.Metadata for .NET to clean metadata from the documents created by a particular author in some directory. Steps include: 1) Scan all documents from an author in a directory (i...
    C# 2 views posted 3 years ago by muhammadsabir
  12. FAV

    How to draw and clear a border around a cell or range of cells from C#

    remove border in excel from C#
    C# 5 views posted 4 years ago by billi8324
  13. FAV

    Calculate the Center Moving Average

    Calculates the center moving average for a time period. The vA requires a range or an array of numbers and the iSteps takes the number of periods in the timeframe (4 for quarters, 7 for weekly, ect)
    Visual Basic saved by 3 people 6 views posted 4 years ago by BDOGG32
  14. FAV

    Extract text from a String

    Two functions that can extract text from a string. Must have the Option Compare Text at the top of the module.
    Visual Basic saved by 2 people 4 views posted 4 years ago by BDOGG32
  15. FAV

    StripCharacters

    Uses regular expressions to do string manipulation. Enter a regular expression into the required parameter and what you want the manipulation to do and it will process the string manipulation. For example if A1 contains John Doe1, Jane Doe2, John W...
    Visual Basic saved by 8 people 4 views posted 4 years ago by BDOGG32
  16. FAV

    SpeedOn and SpeedOff

    Code to turn certain feature off and on for faster running of code in Excel
    Visual Basic saved by 1 person 4 views posted 4 years ago by BDOGG32
  17. FAV

    PHP Excel's PMT() function

    Found elsewhere on the Internet after much searching, this one worked perfectly for me.
    PHP 2 views posted 5 years ago by Dazecoop
  18. FAV

    Mass-strip filenames from the first space

    Replace COL with the cell number.
    DOS Batch 1 views posted 5 years ago by lottegis
  19. FAV

    Convert PDF from Remote Server to other Format using Aspose.Pdf for Cloud API in PHP

    Aspose.PDF for Cloud API has released PHP SDK which allows PHP developers to convert PDF files uploaded to a remote server to other formats. You can pass URL and format parameters to specify the PDF’s URL and output format and use the PUT method of...
    PHP 3 views posted 5 years ago by johansonkatherine
  20. FAV

    Java Code Samples for Converting Charts in Excel Files to Image Files

    The following technical tip show how developers can Convert Chart in excel file to Image in java using Aspose.Cells component. Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data. For instance, r...
    Java 1 views posted 5 years ago by johansonkatherine
  21. FAV

    Java Code Samples for Converting Charts in Excel Files to Image Files

    The following technical tip show how developers can Convert Chart in excel file to Image in java using Aspose.Cells component. Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data. For instance, r...
    Java 1 views posted 5 years ago by johansonkatherine
  22. FAV

    C# and VB.NET Code to Split Worksheets of an Excel Workbook to TIFF or PNG in Cloud

    This technical tip shows how developers can split worksheets of an Excel workbook to a separate workbook, TIFF, PNG or any supported image format in the cloud. This example allows you to split all or specific worksheets of a workbook file and save ea...
    C# 1 views posted 6 years ago by johansonkatherine
  23. FAV

    AutoHotKey | Excel Duplicate current row

    `^!d::` hot key is customizable. `+ ^c^+{+}` is "Shift space ; Ctrl C; Ctrl shift +", stands for "select row; copy; insert". `{Esc}{Down}{Up}` stands for "leave current copy selection; go down then up (to bring back the selection from the whole...
    AutoIt 1 views posted 6 years ago by Ginko
  24. FAV

    Select discrete cells

    Select discrete cells in a sheet
    VB.NET 3 views posted 6 years ago by ducalpha
  25. FAV

    Time Based Gantt Chart in Excel

    I wanted a time based gantt chart in excel. Robert's excel template was very useful. The hourly gantt chart was not useful to visualize my needs. I need something with 10 mins precision to analyse patterns in jobs that are running under 15 mins. So t...
    Visual Basic 5 views posted 6 years ago by mprabhuram
  26. FAV

    Banding of timestamp or date into 5 min bands using excel

    This would round down the time stamp to the nearest 5 minute interval based on first interval being 00:00:00.
    Visual Basic 0 views posted 6 years ago by mprabhuram
  27. FAV

    Change Excel Cell Colors based on whether they contain data or not

    This formula will automatically change a cell's background color if there is data in it. You can also change the formula to only fill cells where there is no data.
    Other 2 views posted 6 years ago by kidmizere
  28. FAV

    Convert Excel file (XLS) to CSV

    Convert Excel file (XLS) to CSV
    C# 7 views posted 6 years ago by engebaja
  29. FAV

    Dictionary loader

    short loop to load a dictionary
    Visual Basic 3 views posted 7 years ago by lolrenx
  30. FAV

    Create Excel file with xlwt and insert in Flask response valid for jquery.fileDownload

    A combinations of 3 technologies. Needed to create Excel files within a Python Flask web framework environment and have it sent via HTTP to client to be handled by the jquery.fileDownload library. Notes: 1. Flask has to set a cookie specified by...
    Python 4 views posted 7 years ago by doronhor
« Prev 1 2 3 4