<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	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/"
	>

<channel>
	<title>Phillip Kuo</title>
	<atom:link href="http://www.phillipkuo.com/blog/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.phillipkuo.com/blog</link>
	<description>Houston Developer</description>
	<lastBuildDate>Thu, 19 Apr 2012 19:57:39 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.8.5</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<item>
		<title>yosemite planning top 6 places</title>
		<link>http://www.phillipkuo.com/blog/?p=285</link>
		<comments>http://www.phillipkuo.com/blog/?p=285#comments</comments>
		<pubDate>Mon, 09 Apr 2012 14:01:37 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=285</guid>
		<description><![CDATA[So we&#8217;ve decided to plan a trip to yosemite national park.  
My top 6 priority places  in yosemite to visit list
1. maroposa grove (map)
2. tuolumne meadows
3. cathedral lakes trail
4. tenaya lake
5. four mile trail
6. raft merced river 
1. wawoana meadow loop
2. gaylor lakes
3. tuolumne grove of giant sequoias
4. elizabeth lake
5. panorama trail
6.  [...]]]></description>
			<content:encoded><![CDATA[<p>So we&#8217;ve decided to plan a trip to yosemite national park.  </p>
<p>My top 6 priority places  in yosemite to visit list<br />
1. maroposa grove (<a href="http://www.nps.gov/yose/planyourvisit/upload/mgrove.pdf">map</a>)<br />
2. tuolumne meadows<br />
3. cathedral lakes trail<br />
4. tenaya lake<br />
5. four mile trail<br />
6. raft merced river </p>
<p>1. wawoana meadow loop<br />
2. gaylor lakes<br />
3. tuolumne grove of giant sequoias<br />
4. elizabeth lake<br />
5. panorama trail<br />
6.  not close to anything : mono lake south tufa trail<br />
7. taft point and fissures </p>
<p>Debating if i should do the http://www.yosemitepark.com/valley-floor-tour.aspx or just go straight into hiking the locations.  </p>
<p>Free Shuttle <a href="http://www.nps.gov/yose/planyourvisit/upload/valleyshuttle.pdf">map</a> through the park.<br />
need to list where the restroom and eat spots are. </p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=285</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>excel 2003/2007: opening files in a new instance</title>
		<link>http://www.phillipkuo.com/blog/?p=277</link>
		<comments>http://www.phillipkuo.com/blog/?p=277#comments</comments>
		<pubDate>Mon, 26 Mar 2012 16:06:20 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[excel]]></category>
		<category><![CDATA[excel-2003]]></category>
		<category><![CDATA[excel-2007]]></category>
		<category><![CDATA[new-window]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=277</guid>
		<description><![CDATA[Ways to open a new excel document in a new excel instance for both 2003/2007.  I sell a button that just opens the file in a new excel instance that saves the time and hassle configuring and installing.  ]]></description>
			<content:encoded><![CDATA[<p>One of the biggest annoyances i&#8217;m dealing with is dealing with excel randomly opening a new file from the windows explorer and it opens up the new file in the existing excel window.  </p>
<p>in other words.<br />
if one excel file is open<br />
click on a new excel file to open<br />
it opens the file in the new excel.<br />
oh how i wish excel was tabbed by documents  the same fashion as chrome or firefox.<br />
in the meantime I&#8217;ll just ask for it to open in a new window.  </p>
<p>I followed this guy&#8217;s tutorial<br />
<a href="http://forums.whirlpool.net.au/archive/850718">http://forums.whirlpool.net.au/archive/850718</a></p>
<p>It looks like a bit of a long-winded solution, but from <a href="http://techrepublic.com.com/520...essageID=2254006">techrepublic.com.com/520&#8230;essageID=2254006</a> :</p>
<blockquote><p>My Computer<br />
Tools<br />
Folder Options<br />
File Types<br />
Choose XLS<br />
Go to Advanced</p>
<p>Uncheck &#8220;browse in same window&#8221; in advanced window.</p>
<p>Then highlight Open<br />
Edit</p>
<p>Make sure in the Action box it says &#038;Open</p>
<p>Make sure in the application used to perform action it says:<br />
&#8220;C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE&#8221; &#8220;%1&#8243;</p>
<p>Check the box next to use DDE </p>
<p>Remove anything that is in DDE Message box and DDE Application Not Running box.</p>
<p>Make sure the application box says: EXCEL</p>
<p>And in the Topic box it says: System</p>
<p>there is also the Excel Advanced option to make it open in a new window:<br />
There is a setting you can enable within Excel 2007, similar to the option there was in 2003, but just a different location due to the changed GUI of course:</p>
<p>1. Open one instance of Excel 2007<br />
2. Click on the Office Button (top left hand corner)<br />
3. Click Excel Options<br />
4. Go to the Advanced section on the left<br />
5. Scroll down to the &#8220;Display&#8221; heading<br />
6. Tick &#8220;Show all windows in the Taskbar&#8221;<br />
7. Close Excel</p>
</blockquote>
<p>Existing problem is when you open from an email attachment, it still does the same thing. </p>
<p>Lockergnome forum has their solution: </p>
<p><a href="http://help.lockergnome.com/office/Open-Excel-Files-Separate-Windows--ftopict706425.html">http://help.lockergnome.com/office/Open-Excel-Files-Separate-Windows&#8211;ftopict706425.html</a></p>
<blockquote><p>By the way, there is a way to solve the &#8220;can&#8217;t open if there are spaces in the filename&#8221;. To get separate windows AND be able to open all files, do this: </p>
<p>1. In Windows Explorer, choose the Tools/Folder Options menu.<br />
2. Click on the File Types tab<br />
3. Scroll down and select the &#8220;XLS Microsoft Excel Worksheet&#8221; item<br />
4. Click the &#8220;Advanced&#8221; button<br />
5. Uncheck the &#8220;Browse in same window&#8221; option </p>
<p>So far this is just like what everyone has been saying&#8230;BUT, it will give you problems opening files that have spaces in them. Continue on to fix that&#8230; </p>
<p>6. Click on &#8220;Open&#8221; in the Actions list<br />
7. Click the &#8220;Edit&#8221; button<br />
8. Click in the &#8220;Application used to perform action:&#8221; box<br />
9. Scroll to the very end. It will say something like &#8230;EXCEL.EXE&#8221; /e %1<br />
10. Put quotes around the %1, so it now ends with &#8230;EXCEL.EXE&#8221; /e &#8220;%1&#8243;<br />
11. Click OK twice, Close once, and you should be in business
</p></blockquote>
<p><a href="http://uploadnsell.com/download/D4CHylCDa2Yn/">Buy the Excel BumpOut Button</a><br />
A button that just pushes out the excel document out into a new instance. </p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=277</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Excel : quick and dirty script to change values in a spreadsheet</title>
		<link>http://www.phillipkuo.com/blog/?p=275</link>
		<comments>http://www.phillipkuo.com/blog/?p=275#comments</comments>
		<pubDate>Fri, 23 Dec 2011 22:12:37 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=275</guid>
		<description><![CDATA[just a quick and dirty script to quickly blank out columns in a spreadsheet.
Sub clearout()
Dim rng As Range, row As Range, cell As Range
Set rng = Range(&#8221;I12:K33&#8243;)
For Each a In rng.Rows
    For Each cell In a.Cells
    cell.Value = &#8220;&#8221;
    Next
Next
Set rng = Range(&#8221;C12:C33&#8243;)
For Each cell In [...]]]></description>
			<content:encoded><![CDATA[<p>just a quick and dirty script to quickly blank out columns in a spreadsheet.</p>
<blockquote><p>Sub clearout()<br />
Dim rng As Range, row As Range, cell As Range<br />
Set rng = Range(&#8221;I12:K33&#8243;)</p>
<p>For Each a In rng.Rows<br />
    For Each cell In a.Cells</p>
<p>    cell.Value = &#8220;&#8221;<br />
    Next<br />
Next<br />
Set rng = Range(&#8221;C12:C33&#8243;)<br />
For Each cell In rng.Cells</p>
<p>    cell.Value = &#8220;&#8221;<br />
    Next<br />
End Sub</p></blockquote>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=275</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Import active python modules from a folder.</title>
		<link>http://www.phillipkuo.com/blog/?p=272</link>
		<comments>http://www.phillipkuo.com/blog/?p=272#comments</comments>
		<pubDate>Tue, 26 Jul 2011 13:05:58 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[python]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=272</guid>
		<description><![CDATA[Import active python modules from a folder. ]]></description>
			<content:encoded><![CDATA[<p>http://www.faqs.org/docs/diveintopython/odbchelper_divein.html<br />
downloaded the file and then put it into a folder. c:\temp\python\ in my case with the commands:</p>
<p>>> import sys<br />
>> sys.path.append(&#8217;c:\\temp\\python\\&#8217;)</p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=272</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MS Excel funny annoyance : can&#8217;t open worksheet in a new window (part 1)</title>
		<link>http://www.phillipkuo.com/blog/?p=264</link>
		<comments>http://www.phillipkuo.com/blog/?p=264#comments</comments>
		<pubDate>Mon, 30 May 2011 06:24:08 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[Office 2003]]></category>
		<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=264</guid>
		<description><![CDATA[MS Excel opening worksheet in a new instance of Excel]]></description>
			<content:encoded><![CDATA[<p>Here is a funny annoyance from MS Excel 2003/2007.  When I click on windows explorer or<br />
Sharepoint links to open excel files, they randomly open in the same instance of excel or they open in their own excel instance.  So I took the liberty of producing a solution which does just that.  Creating a button which pushes the selected worksheet &#8220;out&#8221; into a new Excel instance.  </p>
<p>Here are some forseen issues:<br />
- there needs to be a button in excel to activate the action<br />
- Macro security<br />
- error checking for read-only </p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=264</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>excel vba : for loop cross cell copying</title>
		<link>http://www.phillipkuo.com/blog/?p=260</link>
		<comments>http://www.phillipkuo.com/blog/?p=260#comments</comments>
		<pubDate>Wed, 27 Apr 2011 16:21:38 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[excel]]></category>
		<category><![CDATA[excel vba]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=260</guid>
		<description><![CDATA[quick assignment taking the value from a formulated cell to another and copying it to another and for loop it. 
]]></description>
			<content:encoded><![CDATA[<p>quick assignment taking the value from a formulated cell to another and copying it to another and for loop it. </p>
<p>For i = 68 To 100<br />
Range(&#8221;i&#8221; &#038; i) = Range(&#8221;k&#8221; &#038; i)<br />
Next i</p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=260</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>EDI datetime formats</title>
		<link>http://www.phillipkuo.com/blog/?p=258</link>
		<comments>http://www.phillipkuo.com/blog/?p=258#comments</comments>
		<pubDate>Wed, 06 Apr 2011 15:29:51 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[EDI]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=258</guid>
		<description><![CDATA[list of possible described EDI datetime formats used in request/responses]]></description>
			<content:encoded><![CDATA[<p>It seems X12 and EDIFACT are fairly equivalent regarding dates.<br />
An example of the newer X12 standards for dates would be Data Element 1250<br />
and how it defines the next element; 1251 (The actual date being reported).</p>
<p>Some of the valid values for DE1250 are:</p>
<p>CC &#8211; First two digits of the year expressed in the format CCYY (length of 2)</p>
<p>CM &#8211; Date in Format CCYYMM (length of 6)<br />
CY &#8211; Year Expressed in Format CCYY (length of 4)<br />
D6 &#8211; Complete Date expressed in the format YYMMDD (length of 6)<br />
D8 &#8211; Complete Date expressed in the format CCYYMMDD (length of <img src='http://www.phillipkuo.com/blog/wp-includes/images/smilies/icon_cool.gif' alt='8)' class='wp-smiley' /><br />
DB &#8211; Date Expressed in Format MMDDCYY<br />
DD &#8211; Day of Month in Numeric Format (length of 2)<br />
DT &#8211; Date and Time Expressed in Format CCYYMMDDHHMM (length of 12)<br />
MD &#8211; Month of Year and Day of Month in Format MMDD (length of 4)<br />
MM &#8211; Month of Year in Numeric Format (length of 2)<br />
TM &#8211; Time Expressed in Format HHMM (length of 4)<br />
TS &#8211; Time Expressed in Format HHMMSS (length of 6)<br />
YM &#8211; Year and Month Expressed in Format YYMM (length of 4)<br />
YY &#8211; Last two digits of Year Expressed in Format CCYY (length of 2)<br />
RD2 &#8211; Range of Years Expressed in Format YY-YY (length of 5)<br />
RD4 &#8211; Range of Years Expressed in Format CCYY-CCYY (length of 9)<br />
RD5 &#8211; Range of Years and Months Expressed in Format CCYYMM-CCYYMM (length of<br />
13)<br />
RD6 &#8211; Range of Dates Expressed in Format YYMMDD-YYMMDD (length of 13)<br />
RD8 &#8211; Range of Dates Expressed in Format CCYYMMDD-CCYYMMDD (length of 17)<br />
RDM &#8211; Range of Dates Expressed in Format YYMMDD-MMDD (length of 11)<br />
RDT &#8211; Range of Date and Time, Expressed in Format CCYYMMDDHHMM-CCYYMMDDHHMM<br />
(length of 25)<br />
RMD &#8211; Range of Months and Days Expressed in format MMDD-MMDD (length of 9)<br />
RTM &#8211; Range of Time Expressed in Format HHMM-HHMM (length of 9)</p>
<p>DE1251 is a 35 byte alpha-numeric field.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=258</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>optimizing vista</title>
		<link>http://www.phillipkuo.com/blog/?p=251</link>
		<comments>http://www.phillipkuo.com/blog/?p=251#comments</comments>
		<pubDate>Wed, 15 Dec 2010 23:06:57 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[windows7]]></category>
		<category><![CDATA[umpc]]></category>
		<category><![CDATA[vista optmize for upmc]]></category>
		<category><![CDATA[windows 7]]></category>
		<category><![CDATA[windows vista]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=251</guid>
		<description><![CDATA[tips on how to optimize your umpc running windows vista or windows 7]]></description>
			<content:encoded><![CDATA[<p>An article I used to optimize Windows Vista running on my little UMPC.  Since I primarily use this computer at home, I disabled a number of services which allowed it to run significantly faster. </p>
<p>http://www.optimizingpc.com/vista/optimizing_windows_services.html</p>
<p>disabling aero also helps<br />
http://www.howtogeek.com/howto/windows-vista/disable-aero-on-windows-vista/</p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=251</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MS Access VBA : outputing each record to a new text file</title>
		<link>http://www.phillipkuo.com/blog/?p=249</link>
		<comments>http://www.phillipkuo.com/blog/?p=249#comments</comments>
		<pubDate>Thu, 30 Sep 2010 21:12:40 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[visual-basic]]></category>
		<category><![CDATA[access 2003]]></category>
		<category><![CDATA[vba]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=249</guid>
		<description><![CDATA[outputting database records to their individual text files]]></description>
			<content:encoded><![CDATA[<p>So I recently had to come up with a pretty quick and dirty way to export each record out of a database into a text file.  each record was a broken down email which needed to be output&#8217;d to its whole self again.  </p>
<p>below is the code written in vba: </p>
<p><code>Private Sub Command65_Click()<br />
Dim strSql As String<br />
Dim strSubject As String<br />
Dim strEmailBody As String<br />
Dim fso As New FileSystemObject<br />
Dim i As Integer<br />
Dim ts As Object<br />
Dim rst As Recordset<br />
Set fso = CreateObject("Scripting.FileSystemObject")</p>
<p>strSql = "select top 10 i.uiditem,  i.strEmailSubject, i.strEmailBody from tblpcs_ch_entitybin e inner JOIN tblkepsitem i on e.uidcollection = i.uidcollection and e.uiditem = i.uiditem where e.chbinno like 'SUBJECT MISSING"</p>
<p>Set rst = CurrentDb.OpenRecordset(strSql, dbOpenDynaset, dbSeeChanges)<br />
'rst.MoveLast<br />
i = 0<br />
Do Until rst.EOF</p>
<p>    strSubject = "Subject: " &#038; rst!strEmailSubject &#038; vbCr &#038; vbNewLine &#038; rst!strEmailBody<br />
    Set ts = fso.CreateTextFile("c:\temp\" &#038; i &#038; ".txt", True)<br />
    ts.Write strSubject<br />
    ts.Close<br />
    Set ts = Nothing</p>
<p> 'MsgBox (strSubject)<br />
 i = i + 1<br />
 rst.MoveNext<br />
Loop</p>
<p>End Sub</code></p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=249</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>deactivate google voice forwarding</title>
		<link>http://www.phillipkuo.com/blog/?p=248</link>
		<comments>http://www.phillipkuo.com/blog/?p=248#comments</comments>
		<pubDate>Fri, 24 Sep 2010 18:51:35 +0000</pubDate>
		<dc:creator>Phillip Kuo</dc:creator>
				<category><![CDATA[google voice]]></category>

		<guid isPermaLink="false">http://www.phillipkuo.com/blog/?p=248</guid>
		<description><![CDATA[Wireless Carrier or Network &#8212;> Deactivation Code
AT&#038;T Cingular, T-Mobile, GSM network: ##004#
Verizon (CDMA network): *73 AND *900 AND *920
Verizon (TDMA Network): *740 AND *730
Bluegrass Cellular: *900 AND *920
Cellcom: *680
Cincinnati Bell: ##004#
US Cellular: *740
]]></description>
			<content:encoded><![CDATA[<p>Wireless Carrier or Network &#8212;> Deactivation Code<br />
AT&#038;T Cingular, T-Mobile, GSM network: ##004#</p>
<p>Verizon (CDMA network): *73 AND *900 AND *920</p>
<p>Verizon (TDMA Network): *740 AND *730</p>
<p>Bluegrass Cellular: *900 AND *920</p>
<p>Cellcom: *680</p>
<p>Cincinnati Bell: ##004#</p>
<p>US Cellular: *740</p>
]]></content:encoded>
			<wfw:commentRss>http://www.phillipkuo.com/blog/?feed=rss2&amp;p=248</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>

