You can play YouTube videos outside YouTube using VLC media player. Below are the simple steps to watch YouTube video in VLC media player. Steps Open VLC media player (make sure you have the updated one, else download) Go to VLC Menu -> Open Media -> click “Open Network …” Enter YouTube video URL and click on […]
It is easy to watch YouTube videos in slow motion or fast-motion. The YouTube player lets you set the playback speed of videos. Below article explains step by step instructions to play the YouTube video in slow or fast motion. Steps to play YouTube videos in slow-motion or fast-motion Go to YouTube Open any video […]
VBA code to read a character within a string. Case 1: Suppose the string is “ Excel VBA macro”, and you want to read a character before BA (i.e. V) within that string. VBA code:
inputStr = "Excel VBA macro"
charac = Mid(inputStr, 7, 1)
MsgBox ("The character is " & charac)
When you run above macro, below message box is displayed. Case 2: Suppose the string is too long and […]
Recently, I upgraded my wordpress site from 4.1 to 4.2 version, updated my theme and updated NextGen gallery plugin. It thrown 500- Internal server error when I tried to update NextGen gallery plugin automatically from wp-admin page. So, I updated the plugin manually using FTP. The Nextgen gallery plugin, which was working fine for uploading […]
Excel VBA macro to replace string between two delimiters within a string or text line. This article also explains the usage of Replace function in excel VBA macro. VBA code:
' Macro to replace string "gethow" with "GetHowStuff" in string "welcome to [gethow]"
Dim stringBwDels As String, originalString As String, firstDelPos As Integer, secondDelPos As Integer, stringToReplace As String, replacedString As String
originalString = "welcome to [gethow]"
stringToReplace = "GetHowStuff"
firstDelPos = InStr(originalString, "[") ' position of start delimiter
secondDelPos = InStr(originalString, "]") ' position of end delimiter
stringBwDels = Mid(originalString, firstDelPos + 1, secondDelPos - firstDelPos - 1) 'extract the string between two delimiters
replacedString = Replace(originalString, stringBwDels, stringToReplace)
MsgBox ("replaced string is " + replacedString) ' message shows replaced string
Close #1 ' closing the file
Excel VBA macro to extract string between two delimiters in a text file. This macro extracts string between two delimiters within a string even it contains multiple delimiters. VBA code:
inputFile = Application.GetOpenFilename()
Open inputFile For Input As #1 'Opening the file to read its data
Line Input #1, textline 'reading the first text line
firstDelPos = InStr(textline, "[") ' position of start delimiter
secondDelPos = InStr(textline, "]") ' position of end delimiter
stringBwDels = Mid(textline, firstDelPos + 1, secondDelPos - firstDelPos - 1) ' extract the string between two delimiters
MsgBox (stringBwDels) ' message shows string between two delimiters
Close #1 ' closing the file
Note: If you get any compilation error, highlighting any special character, then delete it and […]
By default, all the files are unhidden or visible on windows. You can make a file or folder hidden or visible by changing its properties. Steps to hide a file or folder on windows 7 Right click on the folder Click on Properties In Attributes, Select Hidden checkbox Click on Apply If the selected folder contains […]
You can change background theme of your Gmail account. Gmail has already provided few themes from which you can choose one and apply it to add some colors to your Gmail account. Steps: Login into your Gmail account Goto Settings button (at top-right) and click on Themes option List of themes such as color, HD, […]
You can use your android mobile camera as webcam. With that, you can have video call, video chat etc on any video based chat or calling application like Yahoo messenger, gtalk, skype etc on your laptop or desktop PC. There are many softwares available on the internet. I tried SmartCam app. Below are the steps. […]
If you are not able to update wordpress automatically, then try steps in below article https://gethowstuff.com/fix-wordpress-auto-update-fail/ If you are still not able to fix the wordpress auto update issue, then install/update wordpress manually. Steps to update wordpress manually Download the latest wordpress version from https://wordpress.org/download/ It is a zip file. Unzip it. Inside the folder, you will […]