Dandelion र Jonathan

कसैले ‘जीवन भनेको योजनामा चल्छ’ भन्छन् त कसैले ‘जीवन अनिश्चितता र आकस्मिकताको भूमरी हो’ भन्छन्। सही के हो थाहा छैन। यहि अ-परिभाषीत वा स्व-परिभाषीत जीवनमा कुनै पूर्व योजना बिना नै अचानक काम (जागिर) परिवर्तन गर्ने वाताबरण बन्यो, अर्को स्टेट सर्नु पर्ने भयो र त्यो सँगै अरु सयौँ कामको बाढि नै आयो। तिनै काम मध्ये आफु बसेको घर अहिलेलाई नबेच्ने बरु भाडामा लगाउने निर्णय भयो, तर मान्छेलाई घर देखाउनु अघि त यसो चिरिच्याँट्ट पार्नु पर्‍यो। घर वरिपरि उम्रेका झारपात हटाउन, दुबोलाई डस्दै उम्रेको Dandelion हटाउन, बगैचामा भएका रुखका हाँगाबिँगा छिमोल्न, झाडी छाँट्न, समग्रमा भन्नु पर्दा जाँगरिला छिमेकिहरुको घर जस्तै पार्न, निकै काम गर्नु पर्ने देखियो।

Excel to GoogleEarth KML - Include Image in the balloons

This post is a follow up to my previous post Excel to GoogleEarth KML. The Excel macro in the previous post would export points and their attribute table to Google Earth.

In this updated version, you can also attach an image at each of selected points along with the image description if available. This version does not have any limitations on number of points and number of attributes you can export (the previous version would not let you have more than 10 attributes). But make sure you do not freeze your computer using 100s of points and attributes :-)

Get file names from a folder using Excel VBA

Get name of the files in a folder

This is an Excel 2007 or later macro that can fetch the name of all the files in a folder.

1. Download the file and open in Excel 2007 or later. If the macro security is not set to Low, you will be asked to Enable macros. Go ahead and enable the Macros.
2. Click the button labelled "Get File Names from a folder"
3. A warning message will pop up saying that the existing data in sheet 1 will be deleted. Click OK
4. A dialog will open allowing you to browse the folder where your files are.
5. Click OK and there you go!!