Profile

Cover photo
w. Patrick Gale
Worked at UNC Chapel Hill
35 followers|272,465 views
AboutPostsPhotosYouTube+1'sReviews

Stream

w. Patrick Gale

Shared publicly  - 
 
If you drop PDF (or other) files in Google Drive and want to have the link to the document download instead of open in Google Drive you need to do some magic (using the old Google Docs URL).

For example I have a PDF with the following link from Google:
https://drive.google.com/file/d/0B9GHDwM1Ruv2Z1gyM3cySG9PbzA/edit?usp=sharing

You need edit the address to look like this:
https://docs.google.com/uc?id=0B9GHDwM1Ruv2Z1gyM3cySG9PbzA&export=download
1
Add a comment...

w. Patrick Gale

Shared publicly  - 
 
Works as advertised.  Great app so far.
The ultimate tool for root users to FREEZE unwanted apps on your droid! Qui...
1
Add a comment...
 
Tired of trying to work around web browser security updates that prevent web pages with local 'file:///' access from working? As an alternative solution to trying to install browser plugins to get around this security feature, you can create a simple C# application in Visual Studio using a WPF forms application template and the web browser component to load the html page with links to local files.  This can be useful when you have a web application that is used to reference files on your local computer.
1
Add a comment...

w. Patrick Gale

Shared publicly  - 
 
Gives new meaning to handle-bar mustache
1
Add a comment...

w. Patrick Gale

Shared publicly  - 
2
w. Patrick Gale's profile photo
 
These are photos of a family of owls perched high in the old growth oak and poplar trees at UNC. Two baby owls were learning to fly and the parents were hunting food. The photos were shot using a 400mm lens.
Add a comment...
Have him in circles
35 people
Brett Cornwright's profile photo
Blake Hardin's profile photo
Trevor Miller's profile photo
Carrie Donley's profile photo
Chris McIver's profile photo
Joe DiConcilio's profile photo
Thomas Morris's profile photo

w. Patrick Gale

Shared publicly  - 
 
THE GRAND BUDAPEST HOTEL recounts the adventures of legendary concierge Gustave H. and Zero Moustafa, the lobby boy who becomes his most trusted friend. The story involves the...
1
Add a comment...

w. Patrick Gale

Shared publicly  - 
 
In Excel, to check to see if a cell, within a column of dates, falls within a date range (using date strings), you must convert the string dates using DATEVALUE like in the following formula:
=IF(AND([@[CHECK_DATE]]>=DATEVALUE("05/06/1999"),[@[CHECK_DATE]]<=DATEVALUE("10/28/2004")),"Within range")
1
Add a comment...
 
Do you have a Word document with lots of words or variables, etc. that you want to replace with other words or phrases?  Well, so did I.

I had a macro enabled Excel document with a column of terms/words (column 1) and a column of replacement terms/words (column 2) that I wanted to use to run a search and replace against a Word document.  Below is the Visual Basic (VBA) macro code I added to my Excel spreadsheet to run a mass search and replace against a Word document.

'--------------- begin code
Sub FindAndReplace()

Set objWord = CreateObject("Word.Application")
objWord.Visible = True

Set objDoc = objWord.Documents.Open("C:\SomeDirectory\MyWordDoc.docx")
Set objSelection = objWord.Selection

Dim find_what, find_repl As String
Dim rowNumbSh1 As Integer
rowNumbSh1 = 1

Set sh1 = ThisWorkbook.Sheets("myExcelWorksheetName")
' range of excel doc
Set Rng = sh1.Range("A:B")

' check each row in the spreadsheet
For Each Row In Rng.Rows
  ' we are ignoring the first row since the first row is a header in my spreadsheet
    If (rowNumbSh1 > 1) Then
        find_what = CStr(sh1.Range("$A" + CStr(rowNumbSh1)).Value)
        find_repl = CStr(sh1.Range("$B" + CStr(rowNumbSh1)).Value)
        objWord.Selection.Find.ClearHitHighlight
        objWord.Selection.Find.ClearFormatting
        objWord.Selection.Find.Replacement.ClearFormatting
        With objWord.Selection.Find
          .Text = find_what
          .Replacement.Text = find_repl
          .Forward = True
          .Wrap = wdFindContinue
          .Format = False
          .MatchCase = False
          .MatchWholeWord = False
          .MatchWildcards = False
          .MatchSoundsLike = False
          .MatchAllWordForms = False
        End With
        objWord.Selection.Find.Execute Replace:=wdReplaceAll
    End If
    ' tell the loop to stop after we have run through the rows we want to search (in my case 500), otherwise the loop will keep going; you could also check to see when there are no values in a row to exit
    If (rowNumbSh1 > 500) Then Exit For
   
     ' increment the row number so we know where we are
    rowNumbSh1 = rowNumbSh1 + 1
Next Row
End Sub
'--------------- end code
1
Add a comment...

w. Patrick Gale

Shared publicly  - 
3
Add a comment...
 
What is you best experiment failure? #scienceFail 
1
Add a comment...

w. Patrick Gale

Shared publicly  - 
 
A view of just one of observatories on the drive up to Kitt Peak
1
Add a comment...
People
Have him in circles
35 people
Brett Cornwright's profile photo
Blake Hardin's profile photo
Trevor Miller's profile photo
Carrie Donley's profile photo
Chris McIver's profile photo
Joe DiConcilio's profile photo
Thomas Morris's profile photo
Basic Information
Gender
Male
Work
Occupation
Handyman
Employment
  • UNC Chapel Hill
Links
Other profiles
Contributor to
w. Patrick Gale's +1's are the things they like, agree with, or want to recommend.
The Lunchbox
market.android.com

A mistaken delivery in Mumbai's famously efficient lunchbox delivery system connects Ila, a neglected housewife, to Saajan (Irrfan Khan), a

The Grand Budapest Hotel
market.android.com

THE GRAND BUDAPEST HOTEL recounts the adventures of legendary concierge Gustave H. and Zero Moustafa, the lobby boy who becomes his most tru

Ice Pirates
market.android.com

Spoofy-goofy comedy, otherworldly special effects, spectacular space creatures, bedraggled 'bots, and biceps-ripplnig swashbuckling highligh

The Lunchbox (Dabba)
www.google.com

Saajan, a Mumbai office worker nearing retirement, is delivered the wrong lunch by a dabbawala. Young housewife Ila had intended it for her

Moonrise Kingdom
market.android.com

Moonrise Kingdom is the new movie directed by two-time Academy Award-nominated filmmaker Wes Anderson (The Royal Tenenbaums, Fantastic Mr. F

App Quarantine ROOT/FREEZE
market.android.com

The ultimate tool for root users to FREEZE unwanted apps on your droid! Quickly get rid of the overrated BLOAT that is added by your phone m

The Walking Dead
market.android.com

When the world is ravaged by a zombie apocalypse, police officer Rick Grimes and a small group of others must face a terrifying new reality.

Captain Phillips
market.android.com

The true story of Richard Phillips, the cargo-ship captain who surrendered himself to a group of Somali pirates so that his crew would be fr

The Doctor's Wife
books.google.com

books.google.com - “The memory starts here, in my apron pocket, with the gun.” So begins The Doctor’s Wife, a stunning debut novel about fou

Gaulart &amp; Maliclet Fast &amp; French Inc.
plus.google.com

Gaulart &amp; Maliclet Fast &amp; French Inc. hasn&#39;t shared anything on this page with you.

The Inn At Middleton Place
plus.google.com

The Inn At Middleton Place hasn't shared anything on this page with you.

Palmetto Carriage
plus.google.com

Palmetto Carriage hasn't shared anything on this page with you.

Biutiful
market.android.com

A man tries to reconcile his desire to be good with his lawless ways in this dark drama from Mexican auteur Alejandro González Iñárritu. Uxb

KNOG
plus.google.com

Knog - Bike light and Bike locks. Bold, Bright, 100% Waterproof

Inglourious Basterds
market.android.com

A group of hardened Nazi killers stalk their prey in Nazi-occupied France as a Jewish cinema owner plots to take down top-ranking SS officer

Mud
market.android.com

A pair of inquisitive adolescents encounter a charismatic drifter with an incredible story in this drama from Take Shelter writer/director J

Public - 2 months ago
reviewed 2 months ago
Great service, not pushy, and great selection. Carlos is the man to see at this store.
Public - 3 months ago
reviewed 3 months ago
Best Chinese food around. The lotus root is very well prepared.
Food: ExcellentDecor: GoodService: Very good
Public - 4 months ago
reviewed 4 months ago
This place was legit. Great service and food.
Public - 6 months ago
reviewed 6 months ago
56 reviews
Map
Map
Map
Quality: Very goodAppeal: Very goodService: Very good
Public - 4 months ago
reviewed 4 months ago
No complaints here. Great location and service and the breakfast was pretty good as well with a great roof top view.
Public - 6 months ago
reviewed 6 months ago
Cute little place for a pit stop while roaming the city.
Public - 6 months ago
reviewed 6 months ago