Skip to content

Instantly share code, notes, and snippets.

View rrbaker's full-sized avatar
🛠️
trying new things

Rob Baker rrbaker

🛠️
trying new things
View GitHub Profile
@rrbaker
rrbaker / ExtractLinksFromWordtoExcel.md
Last active December 19, 2022 17:29
Extract hyperlinked text from a MS Word Doc and extract those URLs in Excel

This is a step-by-step guide to extract all of the hyperlinked text from a Microsoft Word document and then create an Excel spreadsheet with two columns of the original text and the URLs.

For non-technical people, there is code involved in this process, but it's just copy-and-paste from what is provided below. Also, "extracting" doesn't mean that the links are removed from your document; just copied and pasted into a new document and your original document is still unchanged. This is tested against the current version of Word and Excel as of late 2022.

Extracting links from Word

  1. Open the Word document from which you want to extract all the links.

  2. Press the Alt and F11 (Opt-Fn-F11 on Mac) to open the VBA Script Editor.

I am attesting that this GitHub handle rrbaker is linked to the Tezos account tz1ZsmbC1itfSiGcaJuWPJByjACa3F6kwWQh for tzprofiles
sig:edsigtsAX2vUoYtHW1Rzze7LBS2jMxkZziFYc9xqCzZXpQWr99emRQv2ToET5B2N9dyWetXwRGu3NZ5kN88knAt8yVBvSAsyiJ8
@rrbaker
rrbaker / eyeradio_coverage
Created December 9, 2014 16:49
EyeRadio Coverage
{
"type": "FeatureCollection",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "Id": 0 }, "geometry": { "type": "MultiPolygon", "coordinates": [ [ [ [ 32.576928465044546, 4.048265029552169 ], [ 32.565555534955649, 4.048265029552169 ], [ 32.554188265492371, 4.048625395203658 ], [ 32.542837972292432, 4.049345767754062 ], [ 32.531515954157328, 4.050425430055157 ], [ 32.520233481845366, 4.051863307273493 ], [ 32.509001786895453, 4.053657967957747 ], [ 32.497832050484817, 4.055807625458442 ], [ 32.486735392339881, 4.058310139701007 ], [ 32.475722859705286, 4.061163019309333 ], [ 32.464805416384877, 4.064363424077555 ], [ 32.453993931863749, 4.067908167789085 ], [ 32.443299170523403, 4.071793721377446 ], [ 32.432731780959671, 4.076016216429196 ], [ 32.422302285414219, 4.080571449022443 ], [ 32.412021069329853, 4.085454883898706 ], [ 32.401898371040
### Keybase proof
I hereby claim:
* I am rrbaker on github.
* I am rrbaker (https://keybase.io/rrbaker) on keybase.
* I have a public key whose fingerprint is 9A86 86D8 5E6D 81BA 1F9A 004A BECE D54E 0A6E 81CF
To claim this, I am signing this object: