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 188 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 161 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 202 posted 4 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 211 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 376 posted 4 years ago by sherazam
Lists all filenames in a directory if you need them for formulae or add into VBA.
0 185 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 806 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 176 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 123 posted 4 years ago by cueballrawn
VBA to unhide all worksheets in an Excel workbook.
0 181 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 165 posted 4 years ago by muhammadsabir
remove border in excel from C#
0 288 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 176 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 158 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 132 posted 5 years ago by BDOGG32
Code to turn certain feature off and on for faster running of code in Excel
1 195 posted 5 years ago by BDOGG32
Found elsewhere on the Internet after much searching, this one worked perfectly for me.
0 188 posted 6 years ago by Dazecoop
Replace COL with the cell number.
0 111 posted 6 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 420 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 231 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 184 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 249 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 182 posted 6 years ago by Ginko
Select discrete cells in a sheet
0 109 posted 7 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 151 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 134 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 109 posted 7 years ago by kidmizere
Convert Excel file (XLS) to CSV
0 460 posted 7 years ago by engebaja
short loop to load a dictionary
0 88 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 255 posted 7 years ago by doronhor
« Prev 1 2 3 4