Snipplr

(Visual Basic) Read data from txt files - buglilorenzo

Wed, 18 Oct 2017 21:06:05 UTC

Read data from TXT files to import them in Excel environment

(Visual Basic) Excel (VBA) worksheet password cracker (Ver 2010 & below) - cueballrawn

Fri, 25 Nov 2016 21:10:01 UTC

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) Excel (VBA) drop down list multiple values in single cell - cueballrawn

Wed, 10 Aug 2016 01:54:42 UTC

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) Excel (VBA) Custom right-click menu to launch macros - cueballrawn

Wed, 27 Jul 2016 23:54:41 UTC

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.

(C#) How to Set Line Spacing of a Paragraph in an Excel Shape or Textbox inside .NET Apps - sherazam

Wed, 27 Jul 2016 18:24:58 UTC

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 and TextParagraph.SpaceAfter respectively. The following example shows how to Set Line Spacing of the Paragraph in a Shape or Textbox.

(Visual Basic) Excel (VBA) list all filenames in a directory - cueballrawn

Fri, 22 Jul 2016 19:51:10 UTC

Lists all filenames in a directory if you need them for formulae or add into VBA.

(Visual Basic) Excel (VBA) Hash string using SHA1 - pseudonymisation - cueballrawn

Thu, 16 Jun 2016 19:13:58 UTC

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) Access (VBA) Open and run macro from an Excel workbook - cueballrawn

Mon, 13 Jun 2016 20:05:00 UTC

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) Excel (VBA) hide specific worksheets - cueballrawn

Mon, 13 Jun 2016 19:45:48 UTC

Hide specific worksheets in a workbook that contain a prefix. This example uses "Admin_", although this can be changed easily.

(Visual Basic) Excel (VBA) unhide all worksheets - cueballrawn

Mon, 13 Jun 2016 19:35:24 UTC

VBA to unhide all worksheets in an Excel workbook.

(C#) Clean metadata from documents created by a particular author - muhammadsabir

Wed, 08 Jun 2016 20:35:42 UTC

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 (input) 2) Clean metadata associated with the documents. 3) Save documents without metadata in a new directory (output)

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

Wed, 10 Jun 2015 09:24:39 UTC

remove border in excel from C#

(Visual Basic) Calculate the Center Moving Average - BDOGG32

Tue, 14 Apr 2015 08:58:47 UTC

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) Extract text from a String - BDOGG32

Wed, 01 Apr 2015 09:23:42 UTC

Two functions that can extract text from a string. Must have the Option Compare Text at the top of the module.

(Visual Basic) StripCharacters - BDOGG32

Wed, 01 Apr 2015 09:14:22 UTC

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 Wayne3 and you wanted to strip all the numbers out of it you could enter this formula: =RegexReplace(I22,"[^a-zA-Z, ]", ""). This strips all characters that are not a through z or a comma or space. Since all numbers are not in there then it removes them. If you wanted to strip out all alpha characters and leave only the numbers it would look like: =RegexReplace(I22,"[^1-9, ]", "")

(Visual Basic) SpeedOn and SpeedOff - BDOGG32

Wed, 01 Apr 2015 08:51:56 UTC

Code to turn certain feature off and on for faster running of code in Excel

(PHP) PHP Excel's PMT() function - Dazecoop

Thu, 18 Sep 2014 00:41:26 UTC

Found elsewhere on the Internet after much searching, this one worked perfectly for me.

(DOS Batch) Mass-strip filenames from the first space - lottegis

Tue, 19 Aug 2014 05:19:56 UTC

Replace COL with the cell number.

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

Fri, 11 Apr 2014 18:31:54 UTC

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 the convert resource to convert remote PDF files. You can download Aspose Cloud PHP SDK from the link given below: https://github.com/asposeforcloud/Aspose_Cloud_SDK_For_Php The following code sample shows how you can use Aspose Cloud PHP SDK to convert PDF from remote server to TIFF image. You can define any format you want your PDF to convert to in â€œconvertByUrl methodâ€. You can view code for other languages on this page given below. http://www.aspose.com/docs/display/pdfcloud/Convert+PDF+from+Remote+Server+to+other+Formats

(Java) Java Code Samples for Converting Charts in Excel Files to Image Files - johansonkatherine

Fri, 28 Feb 2014 14:09:28 UTC

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, rather than analyzing columns of worksheet numbers, a chart shows at a glance whether sales are falling or rising, or how actual sales compare to projected sales. People are frequently asked to present statistical and graphical information in an easy to understand and an easy to maintain manner. A picture helps. Sometimes, charts are needed in an application or web pages. Or it might be needed needed for a Word document, a PDF file, a PowerPoint presentation or some other application. In each case, you want to render the chart as an image so that you can use it elsewhere. Aspose.Cells for Java has supported converting charts in Excel files to image files since release 2.1.2.

(Java) Java Code Samples for Converting Charts in Excel Files to Image Files - johansonkatherine

Fri, 28 Feb 2014 14:04:04 UTC

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

Thu, 13 Feb 2014 19:29:55 UTC

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 each worksheet as a new workbook, TIFF or any supported image format using Aspose.Cells for Cloud API in your applications. You can use our REST API with any language: .NET, Java, PHP, Ruby, Rails, Python, jQuery and many more. Some of the code samples are provided for the above languages.

(AutoIt) AutoHotKey | Excel Duplicate current row - Ginko

Thu, 19 Dec 2013 22:01:37 UTC

`^!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 row to the current cell only)".

(VB.NET) Select discrete cells - ducalpha

Tue, 06 Aug 2013 15:57:56 UTC

Select discrete cells in a sheet

(Visual Basic) Time Based Gantt Chart in Excel - mprabhuram

Sat, 15 Jun 2013 03:53:16 UTC

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 the following is the formula that i used to achive it. Its not perfect and i dont have time for perfect right now. Some time later i will have to get back to this and publish a excel template.

(Visual Basic) Banding of timestamp or date into 5 min bands using excel - mprabhuram

Thu, 13 Jun 2013 02:43:19 UTC

This would round down the time stamp to the nearest 5 minute interval based on first interval being 00:00:00.

(Other) Change Excel Cell Colors based on whether they contain data or not - kidmizere

Thu, 13 Jun 2013 00:23:58 UTC

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.

(C#) Convert Excel file (XLS) to CSV - engebaja

Wed, 08 May 2013 16:54:17 UTC

Convert Excel file (XLS) to CSV

(Visual Basic) Dictionary loader - lolrenx

Fri, 04 Jan 2013 20:05:22 UTC

short loop to load a dictionary

(Python) Create Excel file with xlwt and insert in Flask response valid for jquery.fileDownload - doronhor

Fri, 04 Jan 2013 02:46:09 UTC

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 jquery.fileDownload 2. Divided code into blocks of code that can be maybe reusable in functions 3. 'app' is not declared but it is obvious a Flask application object relevant projects: 1. http://flask.pocoo.org/ 2. pypi.python.org/pypi/xlwt and www.python-excel.org/ 3. https://github.com/johnculviner/jquery.fileDownload

(Visual Basic) Range to String - lolrenx

Thu, 20 Dec 2012 02:59:14 UTC

Concatenate all text in cells with defined separator

(Visual Basic) Format Header Range - lolrenx

Thu, 20 Dec 2012 02:56:27 UTC

quick way to get column headers formatted

(Visual Basic) Datarange as Class - lolrenx

Thu, 20 Dec 2012 02:53:17 UTC

consider currentregion as a 'datarange' custom class

(Visual Basic) Copy rows based on criteria to a new sheet or file - angelia

Thu, 15 Nov 2012 05:57:12 UTC

Copy rows based on criteria to a new sheet or file

(Visual Basic) 'Append data from multiple worksheet to single worksheet macro - angelia

Thu, 15 Nov 2012 05:54:53 UTC

'Append data from multiple worksheet to single worksheet macro

(C#) .NET - C# - Interop - Excel - Utility/Wrapper Class - denakitan

Sat, 20 Oct 2012 04:21:00 UTC

Utility class that abstracts the creation of a Excel spreadsheet through Interop, and helps on adding and format its contents.

(Visual Basic) Return File Reference - sjmoorecouk

Tue, 18 Sep 2012 23:01:12 UTC

Used to invoke a GetSaveAsFileName dialogue box

(Other) Lookup Belgian provinces in Excel based on postal code - shahways

Thu, 31 May 2012 19:01:38 UTC

Assuming that cell E15 contains a Belgina code consisting of four numbers

(Visual Basic) Convert Excel plain text links to hyperlinks - kidmizere

Wed, 07 Mar 2012 15:00:09 UTC

Save the following code as a macro and then apply it to the fields you want to convert

(Visual Basic) Summary Numerical Count - sjmoorecouk

Fri, 17 Feb 2012 03:36:19 UTC

Counts numbers and places the result in row 1. To get this populated click an top row (any) cell and click Yes to the following dialogue box. Only uniquely counts number values, not text.

(Visual Basic) Highlight every other row - kidmizere

Tue, 14 Feb 2012 06:48:58 UTC

Awesome shortcut.

(Other) Excel Convert Epoch Time - silentpro

Sun, 09 Oct 2011 03:47:47 UTC

(Other) Copy data from a column in a spreadsheet to a row in another spreadsheet - palimadra

Mon, 26 Sep 2011 20:47:33 UTC

In Excel, the Transpose function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.

(Other) Count the amount of empty cells in a column in MS Excel spreadsheet - palimadra

Mon, 26 Sep 2011 20:45:50 UTC

(PHP) PHP (Zend) to XLS Excel Spreadsheet - stur

Thu, 18 Aug 2011 01:38:47 UTC

(Visual Basic) MS Excel: Remove all images - mikaelpelle

Mon, 08 Aug 2011 19:55:03 UTC

VBA script to remove all the images present in the active sheet of the Microsoft Excel spreadsheet.

(PHP) Export UTF-8 data in excel with correct encoding - dsoms

Mon, 04 Jul 2011 18:03:28 UTC

If you want to export some utf-8 data into csv/tsv that will be readable by excel with correct encoding you must add special non vissable characters at the begining of file

(Visual Basic) VBA: Export excel range as image and save as file. - win4me

Thu, 02 Jun 2011 06:36:10 UTC

PROBLEM: How to save Excel range into image file. VBA macro in Excel 2007. SOLUTION: Create an empty chart, paste range image into chart area, and Export as image file. Modify code to suite to your needs.

(Visual Basic) Create a Toolbar in excel - Maikel

Fri, 27 May 2011 18:43:05 UTC

(Other) MS Excel: Group by SUM in Excel - hairajeshk

Thu, 05 May 2011 01:59:50 UTC

http://p2p.wrox.com/excel-vba/65142-sum-group-values-based-cell-criteria.html