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 168 posted 2 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 132 posted 3 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 176 posted 3 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 177 posted 4 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 309 posted 4 years ago by sherazam
Lists all filenames in a directory if you need them for formulae or add into VBA.
0 161 posted 4 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 714 posted 4 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 143 posted 4 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 104 posted 4 years ago by cueballrawn
VBA to unhide all worksheets in an Excel workbook.
0 154 posted 4 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 136 posted 4 years ago by muhammadsabir
remove border in excel from C#
0 247 posted 5 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 149 posted 5 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 132 posted 5 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 106 posted 5 years ago by BDOGG32
Code to turn certain feature off and on for faster running of code in Excel
1 157 posted 5 years ago by BDOGG32
Found elsewhere on the Internet after much searching, this one worked perfectly for me.
0 149 posted 5 years ago by Dazecoop
Replace COL with the cell number.
0 89 posted 5 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 366 posted 6 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 194 posted 6 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 151 posted 6 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 214 posted 6 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 151 posted 6 years ago by Ginko
Select discrete cells in a sheet
0 89 posted 6 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 120 posted 7 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 112 posted 7 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 88 posted 7 years ago by kidmizere
Convert Excel file (XLS) to CSV
0 374 posted 7 years ago by engebaja
short loop to load a dictionary
0 71 posted 7 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 214 posted 7 years ago by doronhor
« Prev 1 2 3 4