John Perry | johnfperry

EXCEL: Macros to add borders and Fix dates

March 14, 2019 2:56 pm \ by John Perry


Sub ColumnToDateTime()
'
' ColumnToDateTime Macro
'

'
ActiveCell.Columns("A:A").EntireColumn.Select
Selection.NumberFormat = "yyyy-mm-dd hh:mm:ss"
End Sub



Sub AddBorders()
'
' AddBorders Macro
'

'
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
End Sub

Add buttons.

Posted in: Excel

MP4 to DVD or ISO converter

November 6, 2016 5:05 pm \ by John Perry

Now that you have a good MP4 you might want to make it into a DVD.

Try this site and use DVD Flick.

Add a “title” or MP4 file
Change the Project destination folder at the bottom of the screen to write the DVD folders to.

Click Create DVD

Then either play from the folders (creates one called dvd) or use ImgBurn to create iso or dvd disk.

That’s it!

Posted in: Video \ Tagged: HowTo

How to rip a DVD with CSS and other protection

November 6, 2016 4:05 pm \ by John Perry

Ever rented a DVD which no longer plays on your DVD player or changer? A bit annoying. Take a backup!

Download the free version of WonderFox DVD Ripper Speedy.
Choose the main movie. (In my case I had to choose a couple of tracks as there were two “movies” or episodes.
The only setting I changed was we like to see subtitles

Since WonderFox only saved as MPG we need it to be in an MP4 container to play with our Plex server.

Import the movie into MovieMaker. I still had my copy from when I upgraded Windows from 7 to 10.

I’m just saving using the recommended setting with the Save Movie icon on the right.

That’s it!

Posted in: Music, Video \ Tagged: HowTo

Windows 10 changes – “previous versions” are now File History

October 7, 2016 3:53 pm \ by John Perry

Surprise?! After Windows 7 System Restore no longer keeps backup copies of previous versions of your files. File History isn’t enabled by default, so you can’t restore previous versions of files unless make some changes.

Go to File History and add an external drive.

File History only backs up copies of files that are in the Documents, Music, Pictures, Videos, and Desktop folders and the OneDrive files available offline on your PC. If you have files or folders elsewhere that you want backed up, you can add them to one of these folders.

Surprise #2. It will start backing up every file on your system without asking!

The reason I thought about using this feature is when my old Vista was hacked by ransomware, after I got control of the PC again, I was able to recovery all files (back to the previous version.)

External: Other choices of backing up your data.

Settings:

Make changes here as needed.

Posted in: Windows \ Tagged: Settings

How to save a Facebook Video to your PC local disk

May 31, 2016 1:20 am \ by John Perry

Right click on a video. Choose
1. Show video URL
Copy and paste into a new tab. (I use Chrome)
Replace the www in the URL with https://m.facebook.com/user_name/video/asodufyduafetc/
Now you are on the FB mobile site. Don’t worry if the video looks small. It doesn’t matter.
Click to start the video.
Pause, right click on the screen and select “Save video as” to save to your local disk.