Welcome To Snipplr


Everyone's Recent Snippets Tagged excel



« Prev 1 2 3 4
Read data from TXT files to import them in Excel environment
0 864 posted 6 years ago by buglilorenzo
If you've forgotten a password to an Excel workbook that was created in version 2010 or older. See URL for more details.
0 878 posted 7 years ago by cueballrawn
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.
0 877 posted 7 years ago by cueballrawn
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.
0 972 posted 7 years ago by cueballrawn
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...
0 1793 posted 7 years ago by sherazam
Lists all filenames in a directory if you need them for formulae or add into VBA.
1 914 posted 7 years ago by cueballrawn
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.
0 4330 posted 7 years ago by cueballrawn
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.
0 925 posted 7 years ago by cueballrawn
Hide specific worksheets in a workbook that contain a prefix. This example uses "Admin_", although this can be changed easily.
0 701 posted 7 years ago by cueballrawn
VBA to unhide all worksheets in an Excel workbook.
0 832 posted 7 years ago by cueballrawn
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...
0 843 posted 7 years ago by muhammadsabir
remove border in excel from C#
0 1434 posted 8 years ago by billi8324
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)
1 1056 posted 8 years ago by BDOGG32
Two functions that can extract text from a string. Must have the Option Compare Text at the top of the module.
2 819 posted 8 years ago by BDOGG32
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...
2 907 posted 8 years ago by BDOGG32
Code to turn certain feature off and on for faster running of code in Excel
1 1216 posted 8 years ago by BDOGG32
Found elsewhere on the Internet after much searching, this one worked perfectly for me.
0 1296 posted 9 years ago by Dazecoop
Replace COL with the cell number.
0 649 posted 9 years ago by lottegis
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...
0 2060 posted 9 years ago by johansonkatherine
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...
0 1115 posted 10 years ago by johansonkatherine
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...
0 1076 posted 10 years ago by johansonkatherine
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...
0 1123 posted 10 years ago by johansonkatherine
`^!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...
0 809 posted 10 years ago by Ginko
Select discrete cells in a sheet
0 729 posted 10 years ago by ducalpha
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...
0 637 posted 10 years ago by mprabhuram
This would round down the time stamp to the nearest 5 minute interval based on first interval being 00:00:00.
0 704 posted 10 years ago by mprabhuram
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.
0 666 posted 10 years ago by kidmizere
Convert Excel file (XLS) to CSV
0 2231 posted 10 years ago by engebaja
short loop to load a dictionary
0 563 posted 11 years ago by lolrenx
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...
0 1337 posted 11 years ago by doronhor
« Prev 1 2 3 4