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 171 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 135 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 180 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 182 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 314 posted 4 years ago by sherazam
Lists all filenames in a directory if you need them for formulae or add into VBA.
0 163 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 727 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 152 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 109 posted 4 years ago by cueballrawn
VBA to unhide all worksheets in an Excel workbook.
0 158 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 142 posted 4 years ago by muhammadsabir
remove border in excel from C#
0 253 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 152 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 134 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 110 posted 5 years ago by BDOGG32
Code to turn certain feature off and on for faster running of code in Excel
1 162 posted 5 years ago by BDOGG32
Found elsewhere on the Internet after much searching, this one worked perfectly for me.
0 150 posted 5 years ago by Dazecoop
Replace COL with the cell number.
0 92 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 374 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 200 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 158 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 219 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 156 posted 6 years ago by Ginko
Select discrete cells in a sheet
0 90 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 124 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 114 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 91 posted 7 years ago by kidmizere
Convert Excel file (XLS) to CSV
0 390 posted 7 years ago by engebaja
short loop to load a dictionary
0 73 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 219 posted 7 years ago by doronhor
« Prev 1 2 3 4