Home
Videos uploaded by user “Krish Sanj”
How to create MS Word document automatically with Excel
 
05:53
Generating the MS word report automatically using the excel as data source. Mail merge is used to link data from excel to word. Them a simple macro is run to get the desired record from excel. Download the MS word document and Excel spread sheet used in this video here https://drive.google.com/open?id=0B4UB3eOhhY26TVdvQ3RucW1zb1E Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Twitter @iTwittt https://twitter.com/iTwittt
Views: 35820 Krish Sanj
Spellnumber in Excel   Convert Currency number into text
 
02:08
My channel www.youtube.com/krishnayess This video will show you how to spell a number to text. This is useful in many accounting applications, for eg. for check writing.
Views: 4941 Krish Sanj
How to open Tatasky remote and how to reppair tatasky remote HD+ Recorder
 
05:19
How to open Tatasky remote and how to reppair tatasky remote HD+ Recorder You often see non functioning TV and other devices' remotes. This is mainly due to wear and tear inside the remote. Sometimes you can fix this just opening and cleaning the inside surface. It worked for me. You can also try this at home with ease. Please note this is not a concrete solution for all non functioning remotes. I am sure at least 30% of the remotes does not work due to clogged dust inside the remote. Please comment or thumbs up if see this useful.
Views: 66644 Krish Sanj
How to manipulate date in MS Word
 
13:27
How to manipulate dates in MS Word. If you want to calculate end date, date difference and other date function, you don't have an option but to go for VBA. Unlike Excel, Word does not have any date functions. This video shows a simple macro to do the date math.. Any questions, suggestions ? please comment below Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 3149 Krish Sanj
Spellnumber in MS Word Part 1
 
03:01
Spellnumber in MS Word Converts your numerical value into text Copy the vba code from here https://drive.google.com/file/d/0B4UB3eOhhY26VlYtT2pGelNJOGc/view?usp=sharing Any questions, suggestions ? please comment below Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 3100 Krish Sanj
How to save web pages into PDF mobile format for offline viewing
 
02:00
Android KitKat has built-in feature to save anything into PDF. You can save web pages which are too length as PDF and you can read them later offline. You can change the page setup so that it can be read easily in mobile screen which are little small like 4 to 4.5 inch
Views: 2320 Krish Sanj
MS Word automatic calculations
 
06:37
Useful Tips on Office Automation MS word has a feature to automate the calculations. By using Quick Parts and bookmarks, you can automate the calculations in MS Word itself. Follow the bellow steps to create Salary Report with simple calculations 1. Create the bookmarks for all the variable fields 2. Insert the quick part fields as shown in the video 3. Add a simple macro to update all the fields.
Views: 11793 Krish Sanj
Adding Bluetooth headset to laptop - A2DP profile
 
04:30
How to connect Bluetooth head set to laptop to use with Skype, Gtalk and other messenger services and also for listening music. you need to install A2DP profile in your laptop. download the driver from here http://krishnasr.blogspot.in/2013/05/connecting-bluetooth-headset-with.html Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 http://www.youtube.com/subscribe_widget?p=krishnayess YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 219838 Krish Sanj
How to fix ModelArt 3 channel RC Helicopter
 
02:29
This is how I fixed my 3 channel RC helicopter. There was a problem with gear which connected to lower fan. I just pressed gently so that it is in contact with fan
Views: 3115 Krish Sanj
How to pair logitech wireless mouse with receiver
 
03:01
How to pair your wireless mouse with old receiver. If you have to sync or pair with different nano receiver, follow these steeps. 1. Install SetPoint application from logitech. 2. connect receiver to laptop, keep the wireless mouse switched on. 3. Locate the ConnectUtility.exe under Program files and then Logitech. 4. Double click to open the utility. 5. Follow the on screen steps to re-establish the connection between receiver and wire less mouse. Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 51070 Krish Sanj
How to create MS Word document automatically with Dynamic fields
 
12:05
Useful Tips on Office Automation How to create ms word templates This video shows how to create a template in MS Word using Quick parts, Fields, Bookmarks and VBA macros. Templates are useful for automating word documents. You can store repetitive values somewhere in the bookmark and place them wherever needed. Download the example here http://krishnasr.blogspot.in/2015/05/how-to-create-template-in-ms-word.html There are 3 steps to create MS word templates. Step 1 Create a section of bookmarks, which hold the value you enter. These are hidden. Step 2 Create field code to populate the values. Use ASK filed to get the values from user and store them in the bookmarks created earlier. Step 3 Create fields where you want to place the values stored in bookmarks. use the FORMULA field to get the value from bookmark and place them wherever you want code REF Bookmark name Finally you can create a macro to update all the values. For this you can create a button and assign the code to it. code Private Sub Update_Click() Fields.Update End Sub Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Twitter @iTwittt https://twitter.com/iTwittt
Views: 195145 Krish Sanj
How to get a list of files in folder in Excel
 
05:15
How to get a list of files in folder in Excel Get the file and their properties in to excel using VBA code Copy the macro code from here https://docs.google.com/document/d/1LIdCDCTqokM7vD_69huhJerTzREqU83xShnKLXtqbNE/edit?usp=sharing My other useful office tips https://www.youtube.com/watch?v=4jnMDgcne2U Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 1998 Krish Sanj
How to share Host internet with Oracle Virtual Machine
 
02:06
Quick trick on how to share host internet connection with Oracle VM. Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 156 Krish Sanj
How to copy files from iPhone to PC using WiFi and AirShare application
 
02:28
File sharing between iPhone and PC is not straight forward. Only photos and videos can be shared using iTunes. With AirShare app you can share any files in the iPhone without iTunes. Connect to common WiFi network. If you don't have common WiFi, then create a ad hoc wifi network. Here is the link https://www.youtube.com/watch?v=RJjOnga2ToI&list=PL0GnEwm2R7wxmADHA75HIuGr9W8AMpPS2&index=1
Views: 13350 Krish Sanj
How to change google chrome as Mobile browser
 
03:38
Change the Google Chrome work as Mobile Browser. There is a Chrome App which will work for you. If you don't want to install anything, you can do this by changing the user agent in settings with out any application.
Views: 878 Krish Sanj
How make PC as WiFi hot spot to share internet
 
01:44
Share you PC internet with other wifi enabled device like other PC mobiles tabs etc. Steps Goto Control Panel Select Network and Internet Select Network and Sharing center Select Setup a new connection or network Select Setup wireless ad hoc network Complete the steps with proper information
Views: 771 Krish Sanj
How to delete blank rows in Excel
 
07:04
How to delete all the blank rows in Excel steps 1. Filter the data with only blank rows visible 2. Select the rows visible 3. Right click and Say "delete rows How to select and copy only filtered rows 1. Apply filter to non blank rows 2. Select the filtered rows 3. press Alt+; which will only select visible rows 4. Copy and paste some where else http://krishnasr.blogspot.in/2013/11/excel-vba-macro-to-swap-2-values-in.html Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 2644 Krish Sanj
MS Excel Currency Converter  Number to Text  - spell number
 
03:18
MS Excel currency converter 3.0 has been update with bug fixes. Bugs fixed in version 3.0 - for 1000 and 100000 it was resulting in null string. Now it has been fixed. Post your questions related to Excel and MS Office https://www.youtube.com/krishnayess http://www.youtube.com/subscribe_widget?p=krishnayess Latest version 3.0 This version has some bug fixes from version 2.0 http://www.youtube.com/watch?v=3JdjeS7YbdA Download file here http://krishnasr.blogspot.in/2013/12/ms-excel-currency-converter-number-to.html Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Facebook: https://www.facebook.com/Office100
Views: 193576 Krish Sanj
How to enable macros in Excel and Word
 
05:35
By default MS Word and MS Excel disable the macros. This video shows how to enable macros
Views: 2955 Krish Sanj
How to make a copy of current document   MS Word automation with dynamic fields
 
07:19
How to make a copy of current document using vba in ms word. It makes use of dynamic fields to create a new document with different values Part 1: how to use dynamic fields in ms word https://www.youtube.com/watch?v=MlzyKniRckQ Get the ms word file here http://krishnasr.blogspot.in/2016/04/how-to-make-copy-of-current-document-ms.html Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Twitter @iTwittt https://twitter.com/iTwittt
Views: 691 Krish Sanj
How to remove page break lines
 
01:43
How to delete lines in MS Word which looks like page breaks You might have tried to remove a line while editing a MS Word document and felt frustrated, since it cannot be removed easily. Basically it is a border to the sentence and to remove it you have to remove the border Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ https://www.facebook.com/Office100
Views: 8774 Krish Sanj
MS Word auto text
 
06:47
MS Word AutoText a gallery under Quick Parts. These are something like document properties. AutoText are used defined document properties. To create an AutoText Select some text on the document and Go to Insert Menu and then go to Quick Parts, select AutoText. Then select the "Save the selection as AutoText". Then select OK. Whenever you want to use the AutoText in the document, just type first few letters of your AutoText, it will appear as an option for you to select. By pressing Enter your complete autotext will be copied to your document. Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Twitter @iTwittt https://twitter.com/iTwittt
Views: 714 Krish Sanj
Spellnumber in MS Word Part 2
 
03:01
Spellnumber in MS Word Converts your numerical value into text Copy the vba code from here https://drive.google.com/file/d/0B4UB3eOhhY26VlYtT2pGelNJOGc/view?usp=sharing Any questions, suggestions ? please comment below Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 1252 Krish Sanj
MS word table of contents with Lead in text emphasis
 
03:53
MS word table of contents with Lead in text emphasis Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Twitter @iTwittt https://twitter.com/iTwittt
Views: 344 Krish Sanj
How to generate loan repayment schedule in Excel
 
05:00
Useful Tips on Office Automation This video shows How to generate loan repayment schedule with the help of PMT excel function
Views: 1073 Krish Sanj
How to remember the passwords seasily
 
05:30
With the evolution of the internet, the online presence has grown manifold. Starting from simple email to bank accounts, from social accounts to online trading account, the online identity is too big to keep everything in mind. To remember all these user IDs and passwords is really a tedious job. There are plenty of apps, websites to remember your password, but do we have to compromise our secrets with some other person. In this video, I have explained how to easily store the password with simple cryptic methods. Though this is just an example to give an idea, it can be sophisticated with more complex algorithms A simple algorithm to store the password in a plain text. 2 simple steps are used to encrypt the password. And the encrypted password can be kept any somewhere in a common place. But the algorithm should be kept secret or heartened. Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Twitter @iTwittt https://twitter.com/iTwittt
Views: 72 Krish Sanj
Android screen mirroring NO ROOT NO CHROMECAST NO MIRACAST
 
05:52
Screen mirroring without root, with out any devices like Chromecast or Miracast. Just a TV with screen mirroring option and a Android mobile with Wireless Display option. In android phone goto settings then display. Select cast screen. In this screen you will see the devices which are available for mirroring. You have to enable "Enable Wireless Displays. It works on the concept of WiFi Direct. You need to setup wifi direct on TV. and connect your mobile on to this wifi. So you will loose the any ohter wifi connection once to connect to screen mirroring. You have to rely on mobile data Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 483021 Krish Sanj
MS Excel user form
 
08:18
Simple and useful neat user form in excel Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 511 Krish Sanj
How to create your own Excel Add-in - Currency converter  - number to text
 
05:43
How to create your own excel add-in - put your user defined function across MS Excel Create your excel macro or user defined function Save it as a add - in Then it is available for any Excel file
Views: 2790 Krish Sanj
How to edit photos and signature for online application
 
05:10
Online applications for banking and other govt. job requires photo and signatures to be scanned and uploaded. It should in specified format like image size and dimensions. It will be very tedious job get the perfect dimensions with correct image size. This video shows how to manually increase the size of an image by adding additional information like comment, tag etc. You can use this method to upload photo and signature for IBPS exams
Views: 42853 Krish Sanj
Greatest Catch Ever!!!!!!!
 
00:29
Amazing catch ever taken by Bichel bowld by Blewett. http://krishnasr.blogspot.com Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 899234 Krish Sanj
Amazing MS Excel tips -  Splitting, Freezing, Auto adjust, Edit multiple sheets
 
04:23
https://www.youtube.com/user/krishnayess/featured?view_as=public MS Excel useful tips to work in worksheets Splitting the worksheet - horizontally Splitting the worksheet - vertically Freezing the header - Rows and columns Hide and unhide rows\columns Edit multiple sheets simultaneously Auto-adjust the column\row width
Views: 1176 Krish Sanj
How to create MS Word document automatically  - Insert file content to word document
 
04:38
Inserting text file content into MS Word document at a specified location. The VBA code does following steps. Create bookmarks in MS Word, open the file and copy the content. Paste the content at the bookmark in the Word document Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 4797 Krish Sanj
Spellnumber in MS Word Part 3
 
03:01
Spellnumber in MS Word Converts your numerical value into text Copy the vba code from here https://drive.google.com/file/d/0B4UB3eOhhY26VlYtT2pGelNJOGc/view?usp=sharing Any questions, suggestions ? please comment below Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 885 Krish Sanj
How to share PC internet connection with Android phones   ad hoc wifi
 
02:14
How to share PC internet connection with Android phones. This is not tethering. Many people are struggling with Ad-Hoc wifi, which fails to connect to Android phone but works with iPhone. This method works fine for Android phones not tested with Apple ones When there is no wifi and you have internet connected to PC either by lan cable or a data card, and you want to share the internet with other android phones, you can follow this video and share your pc internet connection with your Phone you can download the batch files here https://drive.google.com/folderview?id=0B4UB3eOhhY26Vm9GM3dvNjFxazA&usp=sharing
Views: 23293 Krish Sanj
What is the difference between KB and Kb or MB and Mb or GB
 
03:52
What is the difference between KB and Kb or MB and Mb or GB KB = Kilo Byte Kb = Kilo bit MB = Mega Byte Mb = Mega Bit GM = Giga Byte Gb = Giga Bit 1 Byte = 8 Bits Always use KB/MB/GB with file size 200KB, 3.65MB, 3.44GB Always use Kb/Mb/Gb with Data speed Like internet speed, MP3 bit rate etc airtel 4g 40Mbps, Dial-up connection 256kbps etc
Views: 11125 Krish Sanj
How to get unlimited offer from Jio with Samsung.
 
03:08
To get unlimited Jio 4G Preview offer you to install the 4 mandatory applications. JeoBeats, JeonOnDemand, JeoMoney and JeoPlay and click on submit button. You will get unlimited data voice and SMS for 90 days
Views: 6149 Krish Sanj
How to merge 2 MS word documents
 
02:27
How to merge more than 2 documents automatically. Download the macro from here http://krishnasr.blogspot.in/2016/09/how-to-merge-2-or-more-ms-word-documents.html Download the MS Word files which contains the macros from here http://krishnasr.blogspot.in/2016/09/how-to-merge-2-or-more-ms-word-documents.html Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Twitter @iTwittt https://twitter.com/iTwittt
Views: 187 Krish Sanj
Convert currency to word in excel
 
01:17
text to number, Convert currency to word in excel http://krishnasr.blogspot.com/2010/02/convert-currency-to-word-in-excel.html Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Facebook:https://www.facebook.com/Office100
Views: 24181 Krish Sanj
Excel - How to lock Excel cells and How to protect Excel worksheet
 
03:41
This video shows how to lock cells in excel Locking selected cells Locking all the cells in a worksheet Protecting the worksheet from editing
Views: 83 Krish Sanj
iPhone GPRS/EDGE turn off turn on
 
00:44
simple to turn off/ on gprs or edge on iPhone
Views: 39408 Krish Sanj
Excel cell referencing RELATIVE ABSOLUTE and MIXED
 
07:25
If you are working with excel formula, you should know about these three types of cell references - Relative, absolute and Mixed. In relative referencing, you referred address will move when you drag the formula, but in case of absolute, it will not. In mixed type of referencing, you can specify either row or column to move when you drag. Use dollar sign to manipulate the referencing. Put a dollar sign before the column and row to make it absolute. For relative don't use it. In mixed either you put dollar sign before column reference of row reference but not both. Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 623 Krish Sanj
How to create ms word templates in Office 2013
 
22:36
How to create ms word templates This video shows how to create a template in MS Word using Quick parts, Fields, Bookmarks and VBA macros. Templates are useful for automating word documents. You can store repetitive values somewhere in the bookmark and place them wherever needed. Download the example here http://krishnasr.blogspot.in/2015/05/how-to-create-template-in-ms-word.html There are 3 steps to create MS word templates. Step 1 Create a section of bookmarks, which hold the value you enter. These are hidden. Step 2 Create field code to populate the values. Use ASK filed to get the values from user and store them in the bookmarks created earlier. Step 3 Create fields where you want to place the values stored in bookmarks. use the FORMULA field to get the value from bookmark and place them wherever you want code REF Bookmark name Finally you can create a macro to update all the values. For this you can create a button and assign the code to it. code Private Sub Update_Click() Fields.Update End Sub Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 9254 Krish Sanj
Copy paste only filtered values in Excel - Excel tip
 
00:47
Copy paste only filtered values in Excel Steps: Apply filter Filter based on required criterion select filtered rows press Alt + ; copy paste to destination location Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/
Views: 17118 Krish Sanj
Fishes in JP Park Bangalore
 
01:25
Raining fishes in Bangalore ? No.. Stream of fishes in one of the tank in JP Park in Bangalore City. JP park in Mattikere Bangalore is the one of the biggest parks in India. This is a large park with the play area divided into 3 sections and has a variety of equipment for all to play. A small rock garden, with steps and seating areas made of broken glass pieces is a noteworthy attraction of JP Park. The large pond with fish, which come near the shore to gobble up food thrown by the visitors, is yet another thing to experience. This park has a nice and wide walking trail, where you can find many visitors running and jogging. Many elders also walk at a leisurely pace, soaking in the abundant greenery all around. Close to the entrance of this park are big statues of animals and humans, which serve as the ideal backdrop for many a photo taken by the visitors. The musical fountain which is open on weekends is the focal point of this park. Be ready to wait in a long queue though. One of you can volunteer to stand in the queue while the rest head to make a round of the park. There are two shows – one at 7.00 pm and another at 7.45 pm, each is 30 minutes long. Mostly local songs with peppy beats are played with a rare Hindi or English number. Be sure to grab a good seat in the higher rows to enjoy the show to the fullest and click good pictures/videos.
Views: 3973 Krish Sanj
Creating Table for blog
 
01:23
This video shows how to create tables for blogs, without having html knowledge.
Views: 426 Krish Sanj
How to compare 2 MS word document side by side
 
06:10
Useful Tips on Office Automation This video shows how to view two ms word document side by side. By this you can easily review both the documents and compare the changes
Views: 25777 Krish Sanj
Spellnumber    Excel currency converter
 
05:06
Useful Tips on Office Automation
Views: 1007 Krish Sanj
How to add dynamic fields in MS Word
 
01:37
http://www.youtube.com/user/krishnayess This video will show you how to add MS Word fields. These are very useful when you have to add dynamic data into your document. You can extend functionality of fields using VBA code in Document Automation like creating, modifying, and updating the document. There are lots of options with field and VBA. You can create a variable as a placeholder and update the variable with dynamic value by calling a macro/VBA code. Word mail merge uses this field codes to update the dynamic values
Views: 49228 Krish Sanj
How to create MS Word document automatically with  text file
 
11:53
Generating the MS word report automatically using the text file as data source. This is similar to Mail merge to link data from excel to a word. Then a simple macro is run to get the desired record from a text file. Download the MS Word document and the text source file used in this video here https://krishnasr.blogspot.in/2017/08/how-to-create-ms-word-document.html Subscribe to my channel: http://www.youtube.com/user/krishnayess?sub_confirmation=1 YouTube Channel: https://www.youtube.com/krishnayess My Blog: http://krishnasr.blogspot.in/ Google Plus: https://plus.google.com/+KrishSanj/ Twitter @iTwittt https://twitter.com/iTwittt
Views: 270 Krish Sanj