Knowledge.ToString()

Month: September 2014

  • How to Replace VBA Code from Excel/Word

    Have you ever had a situation where you wanted to replace the existing VBA code from Excel/Word and did not want to open up each file and change it? Well, remember that Excel and Word files are nothing but a zip file. You can easily create a program to replace the file from “zip” file.…

    |

  • Excel R1C1 Formula Keeps Coming Back Even When it is Changed

    If you have mix of spreadsheets some of which contains R1C1 formula and if you try to change the R1C1, it comes back in certain spreadsheets. It is extremely frustrating to fix this issue where it is not working as it supposed to work. Here is the solution.

    |

  • .Net Application: How to Use Tokens

    Have you come across an application or library which accepts the %token{format} input and based on token and format, the application calculates the value and uses it. You might wonder how easy it is to accept the token and format for your custom application? Here is the ready made code which helps your application define…

    |