Posts

Listing details of files and folders in a Directory in c#

You can get the list of files and folders in WIndows explorer or in a DOS prompt. It's often useful to get content of a folder dynamically using some scripts or programs, especially if you need these details in some applications. Below is a chunk of C# code which gives you the details for files and folders of a given path. You can add additional fields to your out based on your need. Make an executable file, i.e exe, and use it in your application or run it from the command prompt. Results can be redirected to a text file or csv file. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.IO; namespace WinConsole { class ListFilesOfDirectory { public static long size = 0; public static long totalSizeInMB = 0; public static long maxSizeInMB = 0; public static void listFiles(string path) { DirectoryInfo di = new DirectoryInfo(path); DirectoryInfo[] folders = di.GetDirectories(); long[] listO...

The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) MS Word automation solution

Image
I was frustrated by this error every time I run the below code. I did a lot of googling nothing worked. Even Microsoft said it a known issue we don't recommend this. Then later just to try I just put one try-catch block and it worked perfectly. To date I have not seen that error.

Convert currency to word ( text ) in excel 2.0

Update: New version 3.0 has been released with bug fixes.  Please see this link Version 3.0 Thank you guys for reported bugs in the code (Convert currency to word in excel 1.0) in my earlier post Convert currency to word in excel . Your comments helped me a lot in fixing this error. There is a new version 2.0 which not only has bug fixes but also can convert up to 1,234,567,890.00. You can download the latest version (2.0) from Download You can download the excel from Download Keep commenting

Convert currency to word in excel

There are plenty of online resources to convert Numeric currencies to Text- from $200 to Dollar Two Hundred. But this is applicable only ###,###,### (comma at every third number)format.  This is not suitable for India numbering system, because we follow ##,##,###(....22,22,222) format. So I have create a excel function to over come this. You can use this function to to convert number up to 10,00,00,000(ten crores). How to do it Open Excel Press Alt + F11 From Menu Bar  Insert Module Copy paste the This Module there. Exit from VBA window by pressing Alt + F11 again In excel sheet, Insert Function, Under user defined find   ConvertCurrencyToEnglish  select it and provide the number as a parameter thats all you are done ---------------------------------------------------------------------- Code (alternatively you can download the module from here ) ---------------------------------------------------------------------- ' ...

Enable or Disable GPRS/EDGE in iPhone - The Simple way

Image
I use the iPhone 2g with Bharthi Airtel in  India. It Unlocked and jailbroken. I had a problem with editing APN settings (GPRS/EDGE settings), in fact, it's intentionally done b y Carrier. They are hidden; you will not be able to see Cellular Data Network option under Settings-> General->Network-> Cellular Data Network To enable or disable GPRS the only option, I think, is to change the settings here. To do this all you need is 1.        Jailbroken iPhone with USB Cable 2.        A PC You don't have to worry about Wi-Fi or SSH or WinSCP or even Cydia Download. The procedure –ITS VERY SIMPLE J 1.        Download install iPhone explorer and plist editor for windows they are free and simple use 2.        Connect you iPhone via USB cable (make sure your iTunes recognizes it) 3.        Run iPhone explorer Click on ...

How to change the font size of Browser in iPhone

If you find it difficult to read the text in iPhone browser here is the solution Just follow these steps 1.       Go to any web site you want. 2.       After loading click on the address bar of the browser 3.       Delete whatever you have in the address bar. 4.       Paste the below code in the address bar  javascript:for(i=0;i<document.getElementsByTagName ('*').length;i++)void(document.getElementsByTagName('*' )[i].style.fontSize='18pt'); 5.       Tap on Go button at the bottom Notes: you can change the value 18 to whatever font you want. Make sure that you do not have any New Line character int code.

Connecting Bluetooth Dongle to PC

Having a problem connecting Bluetooth Dongle to your PC? Try these troubleshooting steps. You can try all of them in a sequence or each step in any order. Some of the troubleshooting steps you can try 1. You must see the Bluetooth icon in the system tray (extreme right in the taskbar). a. Right-click on the icon and select settings, under the options tab, check all the checkboxes (there are 4) and try. b. You must pair them(computer and mobile) before transferring files. 2. If there is no Bluetooth icon in the system tray, unplug and plug it again into the USB port. Then do the settings part. 3. You can transfer files in 2 ways – a. one- there will be software provided with the dongle. You can use that b. two- you just install the driver of Bluetooth dongle and right-click on the Bluetooth icon and say RECEIVE A FILE or SEND A FILE. 4. You may have to do some workarounds to make it work.