<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>Technology Rules</title>
	
	<link>http://tech.xnepali.com</link>
	<description>Tech Tips and Technology Updates</description>
	<lastBuildDate>Tue, 19 Jan 2010 17:13:06 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.9.1</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/DesiDanceAndMujraVideos" /><feedburner:info uri="desidanceandmujravideos" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com" /><feedburner:browserFriendly></feedburner:browserFriendly><item>
		<title>Optimize Wordpress for speed and resources</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/PPVBFu3Y-Oo/</link>
		<comments>http://tech.xnepali.com/optimize-wordpress-for-speed-and-resources/#comments</comments>
		<pubDate>Tue, 19 Jan 2010 17:13:06 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tech Tips]]></category>
		<category><![CDATA[Webmaster & scripts]]></category>
		<category><![CDATA[cache]]></category>
		<category><![CDATA[plugin]]></category>
		<category><![CDATA[spam]]></category>
		<category><![CDATA[wordpress]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/?p=124</guid>
		<description><![CDATA[With an experience of running a number of sites/blogs running on Wordpress, I feel like sharing some of the issues I have experienced.
Wordpress if one of the simplest content management system (cms) available. It is easy to install, deploy, and modify when compared to other GPL cms like Joomla, Drupal etc. With a huge user [...]]]></description>
			<content:encoded><![CDATA[<p>With an experience of running a number of sites/blogs running on Wordpress, I feel like sharing some of the issues I have experienced.</p>
<p>Wordpress if one of the simplest content management system (cms) available. It is easy to install, deploy, and modify when compared to other GPL cms like Joomla, Drupal etc. With a huge user base, there is a vast pool of themes and plug-ins (mostly free) to choose from. </p>
<p>When I started using Wordpress in late 2006 the sites I designed didn&#8217;t have much traffic. I had the flexibility to use any plug-in or theme on the sites. But as the traffic increased the server couldn&#8217;t stand it. Then I realized that it was not only the site traffic that determines how much server resource is required to run the site.</p>
<p>The Wordpress core in itself is light-weight but when it is coupled with add-ins and custom themes it can be very resources hungry. The worst resources hog I experienced was a Related Post plug-in. </p>
<p>- Plug-ins can be heavy. Not all plugins are that bad but to be on a safe side; use less number of plug-ins<br />
- Templates with a lot of features and that comes with plugins can also be very heavy.<br />
- Keep homepage as light as possible with less javascript, images and scripts.<br />
- Keep Wordpress updated and secured.<br />
- Spams &#8211; fight them. Nobody needs them and they are heavy on server too. Use plugins like Akismet, Defensio, reCAPTCHA etc.<br />
- Caching &#8211; When site traffic increases the database overload can occur. MySQL database limps trying to get the information needed to render the page. Best solution is to cache the pages so that database gets less load. There are various plug-ins like Wp-Cache, Wp-Super-Cache etc., to do the job.<br />
- Revision &#8211; Latest version of Wordpress features &#8216;revision&#8217;. It is good to have history of every revision made on every post. But, it can be heavy on database too. There are plugins to limit the number of revision or delete revisions to make the database light-weight.</p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/PPVBFu3Y-Oo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/optimize-wordpress-for-speed-and-resources/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/optimize-wordpress-for-speed-and-resources/</feedburner:origLink></item>
		<item>
		<title>Deleting files in Mac</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/o-eN7tLe3lk/</link>
		<comments>http://tech.xnepali.com/deleting-files-in-mac/#comments</comments>
		<pubDate>Fri, 15 Jan 2010 16:59:31 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Mac]]></category>
		<category><![CDATA[Mac OS]]></category>
		<category><![CDATA[PC user in Mac]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/?p=117</guid>
		<description><![CDATA[There is no &#8216;del&#8217; key and the &#8216;backspace&#8217; key is named &#8216;delete&#8217;. The &#8216;delete&#8217; key functions as the PCs backspace and I am fine with that&#8230; what is in a name?
Real problem is the &#8216;del&#8217; key. I still remember the time when I had to struggle in differentiating between the &#8216;backspace&#8217; and &#8216;del&#8217; keys. Now, [...]]]></description>
			<content:encoded><![CDATA[<p>There is no &#8216;del&#8217; key and the &#8216;backspace&#8217; key is named &#8216;delete&#8217;. The &#8216;delete&#8217; key functions as the PCs backspace and I am fine with that&#8230; what is in a name?</p>
<p>Real problem is the &#8216;del&#8217; key. I still remember the time when I had to struggle in differentiating between the &#8216;backspace&#8217; and &#8216;del&#8217; keys. Now, I am longing for one.</p>
<p>It is not that hard to delete files in Mac:</p>
<p> &#8211; Drag to the trash can and empty.<br />
 &#8211; Hold the Control Key while clicking on the file for the sub-menu to delete (move to trash).</p>
<p>Mac OS is based on Linux so I hope the shell command might help. <br />
[rm - remove a file use -r to recursively remove a directory]</p>
<p>But, I miss the luxury of &#8216;Ctrl+Del&#8217;.</p>
<p>As for the regular &#8216;forward delete&#8217; key can be assigned to one of the regular keys in the keyboard by a free software, <a href="http://doublecommand.sourceforge.net/" target="_blank">doublecommand</a>. It however didn&#8217;t work for deleting files.</p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/o-eN7tLe3lk" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/deleting-files-in-mac/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/deleting-files-in-mac/</feedburner:origLink></item>
		<item>
		<title>Screen Capture (Print Screen) in Mac Computer – Mac OS and Windows OS</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/5byzgy3eL1g/</link>
		<comments>http://tech.xnepali.com/screen-capture-print-screen-in-mac-computer-mac-os-and-windows-os/#comments</comments>
		<pubDate>Wed, 13 Jan 2010 04:45:57 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Mac]]></category>
		<category><![CDATA[Windows]]></category>
		<category><![CDATA[Apple computer]]></category>
		<category><![CDATA[Mac Keyboard]]></category>
		<category><![CDATA[Mac OS]]></category>
		<category><![CDATA[Print Screen]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/?p=115</guid>
		<description><![CDATA[For those who have switched from PC to Mac, one of the most obvious difference is the keyboard and its keys. There are some extra ones and some important ones missing.
I was used to taking screenshots by &#8216;Print Screen&#8217; key in PC but the key is missing in the Macbook I recently acquired. It can [...]]]></description>
			<content:encoded><![CDATA[<p><img src="http://blog.xnepali.com/wp-content/uploads/2010/01/™macbook_keyboard0.jpg" alt="macbook_keyboard0.jpg" border="0" width="300" height="200" align="right" />For those who have switched from PC to Mac, one of the most obvious difference is the keyboard and its keys. There are some extra ones and some important ones missing.</p>
<p>I was used to taking screenshots by &#8216;Print Screen&#8217; key in PC but the key is missing in the Macbook I recently acquired. It can take screenshot for sure but in Mac OS the keys are: <strong>⌘-Shift-2</strong></p>
<p>Apart from taking the screenshot the command saves the image in the desktop too. If you don&#8217;t want to save it automatically you need to press one more key. The command <strong>⌘-Shift-Control-2</strong> copies the screen to clipboard.</p>
<p>The key 3 in place of 2 gives more flexibility in selecting what you want to include in the image. </p>
<p>In summary, for Mac OS:</p>
<p><strong>⌘-Shift-2</strong> &#8211; Captures screen and saves in a PNG file<br />
<strong>⌘-Shift-Control-2</strong> &#8211; Captures screen to clipboard<br />
<strong>⌘-Shift-3 </strong>- Captures the selected screen area to a PNG file<br />
<strong>⌘-Shift-Control-3</strong> &#8211; Captures the selected screen area to clipboard</p>
<p>That was for Mac OS. But if you have installed Windows OS using Bootlogger then you would need different keys to do screen capturing. Screen capture keys are fn + F11 for built-in keyboards. For external keyboards, F14 does the job.</p>
<p>Summary for Windows OS:</p>
<p><strong>F14</strong> &#8211; Capture screen (External Mac Keyboard)<br />
<strong>F14 + Option </strong>- Capture the selected area of screen (External Mac Keyboard)</p>
<p><strong>fn + F11</strong> &#8211; Capture screen (Built-in Keyboard)<br />
<strong>fn + Option + F11</strong> &#8211; Capture the selected area of screen (Built-in Keyboard)</p>
<p>In the Mac OS there is &#8216;Grab&#8217; application, found in the Applications folder to take trimmed screenshot. Grab allows you to take a timed screenshot by selecting “Timed Screen” from the Capture menu. Snow Leopard takes this concept a bit further by allowing you to record video of your actions on screen in QuickTime Player.</p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/5byzgy3eL1g" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/screen-capture-print-screen-in-mac-computer-mac-os-and-windows-os/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/screen-capture-print-screen-in-mac-computer-mac-os-and-windows-os/</feedburner:origLink></item>
		<item>
		<title>Office 2010 The Movie (Trailer)</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/YB_bez1IkuY/</link>
		<comments>http://tech.xnepali.com/office-2010-the-movie-trailer/#comments</comments>
		<pubDate>Mon, 11 Jan 2010 21:17:08 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tech fun]]></category>
		<category><![CDATA[ms office]]></category>
		<category><![CDATA[ad]]></category>
		<category><![CDATA[office 2010]]></category>
		<category><![CDATA[the movie]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/office-2010-the-movie-trailer/</guid>
		<description><![CDATA[Microsoft seem to give an impression that the new Office 2010 will be entertaining and fun experience. That should be the reason, Microsoft Office 2010 has come up with a movie trailer for its promotion. It sure is nice movie trailer with love, tragedy, fight… 
Nice ad Microsoft!
Here is the video:



Are you throwing away your [...]]]></description>
			<content:encoded><![CDATA[<p>Microsoft seem to give an impression that the new Office 2010 will be entertaining and fun experience. That should be the reason, Microsoft Office 2010 has come up with a movie trailer for its promotion. It sure is nice movie trailer with love, tragedy, fight… </p>
<p>Nice ad Microsoft!</p>
<p>Here is the video:</p>
<div style="padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px" id="scid:5737277B-5D6D-4f48-ABFC-DD9C333F4C5D:7a818b98-b124-4932-a8f2-c7d5abaaf5a5" class="wlWriterEditableSmartContent">
<div><object width="425" height="355"><param name="movie" value="http://www.youtube.com/v/VUawhjxLS2I&amp;hl=en_US&amp;fs=1&amp;rel=0&amp;hl=en"></param><embed src="http://www.youtube.com/v/VUawhjxLS2I&amp;hl=en_US&amp;fs=1&amp;rel=0&amp;hl=en" type="application/x-shockwave-flash" width="425" height="355"></embed></object></div>
</div>
<p>Are you throwing away your Mac﻿ and buy a PC? You might not need to even if feel like testing it. A Mac version would always be around the corner.</p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/YB_bez1IkuY" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/office-2010-the-movie-trailer/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/office-2010-the-movie-trailer/</feedburner:origLink></item>
		<item>
		<title>Windows 7 – Is it the Lucky 7 for Microsoft?</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/mBI9VxrqNr0/</link>
		<comments>http://tech.xnepali.com/windows-7-is-it-the-lucky-7-for-microsoft/#comments</comments>
		<pubDate>Thu, 22 Oct 2009 06:07:12 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Windows]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/windows-7-is-it-the-lucky-7-for-microsoft/</guid>
		<description><![CDATA[ In the history of Microsoft Windows releases XP is the only successful OS without numbers attached to it. All other named versions failed to gain the consumer confidence in them. Did that made Microsoft superstitions enough to choose the next version with number attached to it &#8212; number 7, lucky 7?
Most of the successful [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://tech.xnepali.com/wp-content/uploads/2009/10/Windows_7_logo.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; margin-left: 0px; border-left-width: 0px; margin-right: 0px" title="Windows_7_logo" border="0" alt="Windows_7_logo" align="right" src="http://tech.xnepali.com/wp-content/uploads/2009/10/Windows_7_logo_thumb.jpg" width="258" height="53" /></a> In the history of Microsoft Windows releases XP is the only successful OS without numbers attached to it. All other named versions failed to gain the consumer confidence in them. Did that made Microsoft superstitions enough to choose the next version with number attached to it &#8212; number 7, lucky 7?</p>
<p>Most of the successful Microsoft Windows releases were numbered and few named versions received disappointing responses except for <a href="http://en.wikipedia.org/wiki/Windows_XP">Windows XP</a>. For example, <a href="http://en.wikipedia.org/wiki/Windows_Me">Windows Me</a> released in 2000 was called &quot;Mistake Edition&quot; by PC World; <a href="http://en.wikipedia.org/wiki/Windows_Vista">Windows Vista</a> could never gain confidence of the XP users. (Network versions &#8211; Windows NTs were released with numbers attached to them).</p>
<p>Windows 7, the new operating system from Microsoft, is going on sale today. It has received some favorable reviews and some new features to help Windows rebuilt its image. Some notable features of the new OS are faster booting, Device Stage, Windows PowerShell, less obtrusive User Account Control, multi-touch, improved window management, homegroup networking, multiple thumbnails for combined taskbar buttons, and better power management for notebooks. </p>
<p>Reviews of final release will tell how the new Windows are perceived by the users. Till then, let’s wish Microsoft luck.</p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/mBI9VxrqNr0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/windows-7-is-it-the-lucky-7-for-microsoft/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/windows-7-is-it-the-lucky-7-for-microsoft/</feedburner:origLink></item>
		<item>
		<title>Meta tag in Blogspot blog</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/run5sM-3_bo/</link>
		<comments>http://tech.xnepali.com/meta-tag-in-blogspot-blog/#comments</comments>
		<pubDate>Sat, 10 Oct 2009 19:15:00 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Webmaster & scripts]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/meta-tag-in-blogspot-blog/</guid>
		<description><![CDATA[ Meta keyword is one of the most important way to optimize your website&#8217;s search ranking. Search engines use meta keyword to filter sites for the search result of query occurred by their search tool. Keywords however should be properly selected to benefit from it. The keywords should be related to the blog in question [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://tech.xnepali.com/wp-content/uploads/2009/10/metatag.jpg"><img style="border-bottom: 0px; border-left: 0px; display: inline; margin-left: 0px; border-top: 0px; margin-right: 0px; border-right: 0px" title="meta tag" border="0" alt="meta tag" align="right" src="http://tech.xnepali.com/wp-content/uploads/2009/10/metatag_thumb.jpg" width="304" height="181" /></a> Meta keyword is one of the most important way to optimize your website&#8217;s search ranking. Search engines use meta keyword to filter sites for the search result of query occurred by their search tool. Keywords however should be properly selected to benefit from it. The keywords should be related to the blog in question and unnecessary or mis-leading keywords can adversely affect the site. </p>
<p>Many blogger (blogspot) users ask question on how to add meta keyword in their blog. Those who have used custom made themes in their blog might have already figured it out but for those who doesn&#8217;t know add meta description: follow the method explained below. </p>
<p><strong>1</strong>. Sign in to your blogger </p>
<p><strong>2</strong>. Click &quot;Layout&quot; tab in Dashboard </p>
<p><strong>3</strong>. Click &quot;Edit HTML&quot;.&#160; (<em>Precaution</em>: Before you change any code, make a habit of backing up your code by clicking “Download Full Template” link. In worst case, you can restore the previous code)</p>
<p><strong>4</strong>. Search following line of code (you can use Ctrl+F to find it) </p>
<pre class="csharpcode"><span class="kwrd">&lt;</span><span class="html">b:include</span> <span class="attr">data</span><span class="kwrd">=&quot;blog&quot;</span> <span class="attr">name</span><span class="kwrd">=&quot;all-head-content&quot;</span> <span class="kwrd">/&gt;</span></pre>
<style type="text/css">
.csharpcode, .csharpcode pre
{
	font-size: small;
	color: black;
	font-family: consolas, "Courier New", courier, monospace;
	background-color: #ffffff;
	/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt 
{
	background-color: #f4f4f4;
	width: 100%;
	margin: 0em;
}
.csharpcode .lnum { color: #606060; }</style>
<p><strong>5</strong>. Copy the following code <strong>below</strong> the code from step 4. </p>
<pre class="csharpcode"><span class="kwrd">&lt;</span><span class="html">meta</span> <span class="attr">content</span><span class="kwrd">='<strong>DESCRIPTION</strong>'</span> <span class="attr">name</span><span class="kwrd">='description'</span><span class="kwrd">/&gt;</span>
<span class="kwrd">&lt;</span><span class="html">meta</span> <span class="attr">content</span><span class="kwrd">='<strong>KEYWORDS</strong>'</span> <span class="attr">name</span><span class="kwrd">='keywords'</span><span class="kwrd">/&gt;</span>
<span class="kwrd">&lt;</span><span class="html">meta</span> <span class="attr">content</span><span class="kwrd">='<strong>AUTHOR</strong>'</span> <span class="attr">name</span><span class="kwrd">='author'</span><span class="kwrd">/&gt;</span></pre>
<style type="text/css">
.csharpcode, .csharpcode pre
{
	font-size: small;
	color: black;
	font-family: consolas, "Courier New", courier, monospace;
	background-color: #ffffff;
	/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt 
{
	background-color: #f4f4f4;
	width: 100%;
	margin: 0em;
}
.csharpcode .lnum { color: #606060; }</style>
<p><strong>6</strong>. Replace the <strong>WORDS</strong> (with bold capital letters) with your appropriate values. </p>
<p><strong>7</strong>. Click on &quot;Save Template&quot; (don&#8217;t forget this most important step <img src='http://tech.xnepali.com/wp-includes/images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' />  ) </p>
<p>You are all done. I wish you all the best with your blog. </p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/run5sM-3_bo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/meta-tag-in-blogspot-blog/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/meta-tag-in-blogspot-blog/</feedburner:origLink></item>
		<item>
		<title>Excel Filename – Copy sheets to new file</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/gPoxcynBXmI/</link>
		<comments>http://tech.xnepali.com/excel-filename-copy-sheets-to-new-file/#comments</comments>
		<pubDate>Mon, 31 Aug 2009 01:50:51 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[VBA]]></category>
		<category><![CDATA[ms office]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/?p=102</guid>
		<description><![CDATA[In the previous post I posted a code to copy data and remove all external references and save as a new file. But for a simple case, I was trying to save a sheet &#8211; as it is &#8211; as a new file.
But, typical to a copy-paste code; a strange error occurred while I tried [...]]]></description>
			<content:encoded><![CDATA[<p>In the <a href="http://tech.xnepali.com/excel-vba-copy-worksheets-and-save-as-a-new-file/">previous post</a> I posted a code to copy data and remove all external references and save as a new file. But for a simple case, I was trying to save a sheet &#8211; as it is &#8211; as a new file.</p>
<p>But, typical to a copy-paste code; a strange error occurred while I tried to get the filename of current sheet through an add-in. I wanted the filename of the excel file I was editing but I kept on receiving the name of add-in. It took me a while to realize that &#8216;ActiveWorkbook&#8217; and &#8216;ThisWorkbook&#8217; behave differently. </p>
<p>?ActiveWorkbook.FullName<br />
C:\Documents and Settings\XXXX\Application Data\Microsoft\AddIns\test.xla</p>
<p>?ThisWorkbook.FullName<br />
C:\Test\test.xlsx</p>
<p>I was copying a sheet and saving it as a new file. If you want to do the same, following subroutine can be handy :</p>
<p><code>Sub CopyMySheet()<br />
    Dim DstFile As String               'Destination File Name<br />
    Dim CurrentFileName As String<br />
    Dim wb As Workbook<br />
        CurrentFileName = ActiveWorkbook.FullName ' returns C:\Test\test.xlsx<br />
        CurrentFileName = Replace(CurrentFileName, ".xlsx", "")<br />
        DstFile = CurrentFileName &#038; "_new" &#038; ".xlsx" ' returns C:\Test\test_new.xlsx<br />
        Worksheets("st_orig").Copy 'Copying original sheet<br />
        Set wb = ActiveWorkbook<br />
        wb.SaveAs DstFile 	'Saving the copy<br />
        wb.Close		'Close the file<br />
End Sub </code></p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/gPoxcynBXmI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/excel-filename-copy-sheets-to-new-file/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/excel-filename-copy-sheets-to-new-file/</feedburner:origLink></item>
		<item>
		<title>Excel VBA – Copy worksheets and save as a new file</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/8AIaf5eKUKw/</link>
		<comments>http://tech.xnepali.com/excel-vba-copy-worksheets-and-save-as-a-new-file/#comments</comments>
		<pubDate>Fri, 28 Aug 2009 20:41:17 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[VBA]]></category>
		<category><![CDATA[ms office]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/?p=96</guid>
		<description><![CDATA[If you copy data from one sheet to another the formula refer back to the original sheet. Doing a &#8216;past special&#8217; and copying only the data can do the trick. But if you need to do such operations for a large number of sheets a VBA macro can be handy:
Sub CopyPasteSave()
    Dim [...]]]></description>
			<content:encoded><![CDATA[<p>If you copy data from one sheet to another the formula refer back to the original sheet. Doing a &#8216;past special&#8217; and copying only the data can do the trick. But if you need to do such operations for a large number of sheets a VBA macro can be handy:</p>
<p><code>Sub CopyPasteSave()<br />
    Dim NewName As String<br />
    Dim nm As Name<br />
    Dim ws As Worksheet</p>
<p>    If MsgBox("Copy specific sheets to a new workbook" &#038; vbCr &#038; _<br />
    "New sheets will be pasted as values, named ranges removed" _<br />
    , vbYesNo, "NewCopy") = vbNo Then Exit Sub</p>
<p>    With Application<br />
        .ScreenUpdating = False</p>
<p>         '       Copy specific sheets<br />
         '       *SET THE SHEET NAMES TO COPY BELOW*<br />
         '       Array("Sheet Name", "Another sheet name", "And Another"))<br />
         '       Sheet names go inside quotes, seperated by commas<br />
        On Error GoTo ErrCatcher<br />
        Sheets(Array("Sheet1")).Copy<br />
        On Error GoTo 0</p>
<p>         '       Paste sheets as values<br />
         '       Remove External Links, Hperlinks and hard-code formulas<br />
         '       Make sure A1 is selected on all sheets<br />
        For Each ws In ActiveWorkbook.Worksheets<br />
            ws.Cells.Copy<br />
            ws.[A1].PasteSpecial Paste:=xlValues<br />
            ws.Cells.Hyperlinks.Delete<br />
            Application.CutCopyMode = False<br />
            Cells(1, 1).Select<br />
            ws.Activate<br />
        Next ws<br />
        Cells(1, 1).Select</p>
<p>         '       Remove named ranges<br />
        For Each nm In ActiveWorkbook.Names<br />
            nm.Delete<br />
        Next nm</p>
<p>         '       Input box to name new file<br />
        'NewName = InputBox("Please Specify the name of your new workbook", "New Copy")</p>
<p>         '       Save it with the NewName and in the same directory as original<br />
        NewName = ThisWorkbook.Name &#038; "_out"<br />
        'ActiveWorkbook.SaveCopyAs ThisWorkbook.Path &#038; "\" &#038; NewName &#038; ".xls"<br />
        ActiveWorkbook.Close SaveChanges:=True</p>
<p>        .ScreenUpdating = True<br />
    End With<br />
    Exit Sub</p>
<p>ErrCatcher:<br />
    MsgBox "Specified sheets do not exist within this workbook"<br />
End Sub</code></p>
<p>This code will ask for the new file name before it closes. You can tweak the code to suit your requirement.</p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/8AIaf5eKUKw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/excel-vba-copy-worksheets-and-save-as-a-new-file/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/excel-vba-copy-worksheets-and-save-as-a-new-file/</feedburner:origLink></item>
		<item>
		<title>MS Office 2010 going cloud</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/ki8RK3z_arA/</link>
		<comments>http://tech.xnepali.com/ms-office-2010-going-cloud/#comments</comments>
		<pubDate>Mon, 13 Jul 2009 21:24:45 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[ms office]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/ms-office-2010-going-cloud/</guid>
		<description><![CDATA[ Microsoft today announced at its Worldwide Partner Conference in New Orleans about the new version of Microsoft Office 2010. In response to Google Apps, Microsoft is going to roll out web browser versions of Word, PowerPoint, Excel and OneNote for free. 
Microsoft and free? Yes, and I am excited. Hopefully, I won’t need to [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://tech.xnepali.com/wp-content/uploads/2009/07/microsoftoffice2010.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; margin-left: 0px; border-left-width: 0px; margin-right: 0px" title="microsoft-office-2010" border="0" alt="microsoft-office-2010" align="right" src="http://tech.xnepali.com/wp-content/uploads/2009/07/microsoftoffice2010_thumb.jpg" width="234" height="89" /></a> Microsoft today announced at its Worldwide Partner Conference in New Orleans about the new version of <a href="http://www.microsoft.com/office/2010/" target="_blank">Microsoft Office 2010</a>. In response to Google Apps, Microsoft is going to roll out web browser versions of Word, PowerPoint, Excel and OneNote for free. </p>
<p>Microsoft and free? Yes, and I am excited. Hopefully, I won’t need to install the bulky Office application in my netbook anymore. </p>
<p>It is told that all these web-based versions of these products will be based in the cloud and will have fewer features than their desktop cousins. Only featuring some basic tools to edit and change documents these tools will surely help in some last minute modification from one’s handheld devices.</p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/ki8RK3z_arA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/ms-office-2010-going-cloud/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/ms-office-2010-going-cloud/</feedburner:origLink></item>
		<item>
		<title>Task Manager in Chrome</title>
		<link>http://feedproxy.google.com/~r/DesiDanceAndMujraVideos/~3/hleLjIxSRR0/</link>
		<comments>http://tech.xnepali.com/task-manager-in-chrome/#comments</comments>
		<pubDate>Thu, 09 Jul 2009 22:52:06 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[recent]]></category>

		<guid isPermaLink="false">http://tech.xnepali.com/task-manager-in-chrome/</guid>
		<description><![CDATA[In the recent news Google is planning to release a full-fledged operating system. Hopefully it will have less compatibility and crash issues. I had been in and out of Chrome browser due to its incompatibility with Yahoo mails (messenger feature) and Hotmail. Looks like they are solved now. The best thing I like about the [...]]]></description>
			<content:encoded><![CDATA[<p>In the recent news Google is planning to release a full-fledged operating system. Hopefully it will have less compatibility and crash issues. I had been in and out of Chrome browser due to its incompatibility with Yahoo mails (messenger feature) and Hotmail. Looks like they are solved now. The best thing I like about the colorful browser is the simplicity, tabs and its own unique &#8220;Task manager&#8221;.</p>
<p>I use the Windows Task Manager a lot to close unresponsive and memory hogging application. The Chrome task manger is also helpful in closing those plugins like Flash, Java, or unresponsive tabs.</p>
<p>To start task manager in Chrome:<br />
press <strong>Shift+Esc</strong> keys</p>
<p><img class="alignnone size-full wp-image-82" title="chrome_taskmanager" src="http://tech.xnepali.com/wp-content/uploads/2009/07/chrome_taskmanager.jpg" alt="chrome_taskmanager" width="468" height="299" /></p>
<p>Now you can select the plugin or tab and click <strong>End process</strong> to close it.</p>
<img src="http://feeds.feedburner.com/~r/DesiDanceAndMujraVideos/~4/hleLjIxSRR0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://tech.xnepali.com/task-manager-in-chrome/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://tech.xnepali.com/task-manager-in-chrome/</feedburner:origLink></item>
	</channel>
</rss>
